SQL Error: Syntax Error (Missing Operator) in Query Expression

Question

Ok so here my code.

SELECT Department, COUNT(*) AS CountByTechAndMP
FROM Course
GROUP BY Department
WHERE MPCategory IS NOT NULL AND Technical = true;

I have been trying to fool with it but I just can't seem to get it. I feel like it is something easy that I am just missing.

Eugen Rieck · Accepted Answer · 2014-04-27 23:50:39Z

1

GROUP BY goes after WHERE

SELECT Department, COUNT(*) AS CountByTechAndMP
FROM Course
WHERE MPCategory IS NOT NULL AND Technical = true
GROUP BY Department

answered Apr 27, 2014 at 23:50

Eugen Rieck

65.6k10 gold badges76 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1