Advertisement
Guest User

sql-linking

a guest
Dec 13th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.29 KB | None | 0 0
  1. 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