sql统计分组的组数

SELECT COUNT(*) from (SELECT * from enroll GROUP BY org_id) newtable;

例子

查询攻击的类别数

SELECT "count"(*) from (SELECT event_type from internal_app_bsackc."event" group by event_type) as a;