力扣（leetcode）586和596题（MySQL）

586 订单最多的客户

题目链接：586.订单最多的客户

解答

select customer_number from Orders group by customer_number order by count(*) desc limit 1;

596 超过5名学生的课

题目链接：596.超过5名学生的课

解答：

select class from Courses group by class having count(*)>=5;