order by the summed value groupby

PHOTO EMBED

Wed Aug 10 2022 06:33:17 GMT+0000 (UTC)

Saved by @vnmshenoy

select last_name,first_name,sum(salary)
from employees
group by last_name,first_name
order by sum(salary) desc
content_copyCOPY

https://learnsql.com/track/sql-from-a-to-z/course/sql-queries/order-by-group-by/having/order-groups