Advertisement
Guest User

Untitled

a guest
Dec 11th, 2019
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. SELECT employees.emp_no, employees.first_name AS "First name", SUM(salary) AS "Salary > 1,000,000" FROM salaries JOIN employees ON salaries.emp_no = employees.emp_no GROUP BY emp_no HAVING SUM(salary) > 1000000 ORDER BY SUM(salary) DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement