Experts, I'm using the query below to pull data from the db, and want to add a clause of WHERE count(misconcepion) >=4, but I keep getting an error when I do. Can someone tell me how to add this clause to my query?
SELECT ss.studentID, s.fName,s.lName, count(misconception) AS misc
FROM studentmisconceptionreport ss
INNER JOIN students s on s.studentID = ss.studentID
WHERE itemsetID = 65
group by ss.studentID