SQL 语句中 WHERE 和 GROUP BY 子句的顺序问题

有错误，WHERE 子句应该放在 GROUP BY 子句之后，正确的语句应该是：

SELECT university, COUNT(*) question_cnt FROM user_profile up LEFT JOIN question_practice_detail qpd ON up.device_id = qpd.device_id WHERE MONTH(date) = 8 AND university = '复旦大学' GROUP BY university;