SELECT sum(count( EmpId ))
FROM(
SELECT count( EmpId ),JobTitle
FROM ASSIGNMENT, JOB
WHERE JOB.JobTitle like '%manager%'
AND ASSIGNMENT.JobId =JOB.JobId
GROUP BY JOB.JobTitle
)


error message:
Result: no such column: EmpId
At line 1:
SELECT sum(count(EmpId))
FROM(
SELECT count( EmpId ),JobTitle
FROM ASSIGNMENT, JOB
WHERE JOB.JobTitle like '%manager%'
AND ASSIGNMENT.JobId =JOB.JobId
GROUP BY JOB.JobTitle
)