SELECT last_name,first_name,
avg(salary) as average_salary,count(distinct year) as years_worked 
from employees
group by last_name,first_name
having years_worked >2
order by average_salary desc
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter