Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT loc.state, SUM(Salary)
- FROM emp
- INNER JOIN loc on emp.locid = loc.locid
- GROUP BY loc.state
- ORDER BY SUM(Salary) Desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement