如果要使用 SQL 统计团课次数、一起上课总人数和谁上课最多,可以使用以下语句:
统计团课次数:
SELECT COUNT(DISTINCT class_id) FROM class;
统计一起上课总人数:
SELECT SUM(number_of_students) FROM class;
查询谁上课最多:
SELECT instructor, COUNT(*) as class_count FROM class GROUP BY instructor ORDER BY class_count DESC LIMIT 1;
假设表名为 class, class_id为每次团课编号, number_of_students 为此次团课学员人数, instructor 是团课教练.