SELECT MAX(a1.人数) FROM (SELECT COUNT(category_id) AS "人数",category_id FROM course_category_course category WHERE category.course_id IN (‘ZZZ-050‘,‘00000021‘,‘00306‘) GROUP BY category_id) a1;
获取最大种类
原文：https://www.cnblogs.com/deepalley/p/11989324.html