Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT title, COUNT(*) FROM departments, dept_emp, employees, salaries, titles WHERE departments.dept_no = dept_emp.dept_no AND employees.emp_no = dept_emp.emp_no AND salaries.emp_no = employees.emp_no AND titles.emp_no = employees.emp_no AND departments.dept_name = 'Sales' GROUP BY titles.title
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement