Advertisement
Guest User

Untitled

a guest
Jun 18th, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.18 KB | None | 0 0
  1. SELECT COUNT(EMPLOYEE_ID)
  2. FROM EMPLOYEES E, JOB_HISTORY H, JOBS J
  3. WHERE E.employee_id = H.employee_id AND H.job_id = J.job_id AND end_date IS NOT NULL AND job_title = 'Stock Clerk'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement