SHARE
TWEET

Untitled

a guest May 23rd, 2019 71 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT sum(count( EmpId ))
  2. FROM(
  3. SELECT count( EmpId ),JobTitle
  4. FROM ASSIGNMENT, JOB
  5. WHERE JOB.JobTitle like '%manager%'
  6. AND ASSIGNMENT.JobId =JOB.JobId
  7. GROUP BY JOB.JobTitle
  8. )
  9.  
  10.  
  11. error message:
  12. Result: no such column: EmpId
  13. At line 1:
  14. SELECT sum(count(EmpId))
  15. FROM(
  16. SELECT count( EmpId ),JobTitle
  17. FROM ASSIGNMENT, JOB
  18. WHERE JOB.JobTitle like '%manager%'
  19. AND ASSIGNMENT.JobId =JOB.JobId
  20. GROUP BY JOB.JobTitle
  21. )
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top