Leetcode 596 Classes More Than 5 Students （SQL-Oracle）

 答案：  select class,count(*) from COURSES  group by class having count(distinct student)>5

                                    我用的是Oracle   先创建个表  执行如下语句

-- Create table
create table COURSES
(
  student VARCHAR2(50),
  class   VARCHAR2(50)
)
tablespace YYQINPUT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    next 1
    minextents 1
    maxextents unlimited
  );

统计class 数量超过5的，那么如何统计一下呢？

第一步   查询数量  group by：

select class,count(*)   from COURSES group by class  

select class,count(*) from COURSES  group by class having count(distinct student)>4

第二步  having count( distinct    student )>5

select class,count(*) from COURSES  group by class having count(distinct student)>5