Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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