max count混合使用

?

1 2	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;

　　获取最大种类