DB Lab 1 Discprepancies

q9.sql

Your Answer:

with stable as 
(select course_id, sec_id, year, semester, count(ID) as numstu from takes
group by course_id, sec_id, year, semester),
enrol(max_enroll) as 
(
select max(numstu) from stable
)
select course_id, sec_id, year, semester, numstu from stable, enrol
where numstu = enrol.max_enroll;

Hide Instructor Answer
Instructor's Answer:

 with enrollment as 
          (select course_id, sec_id, year, semester, count(*) as number
           from  takes
           group by course_id, sec_id, year, semester),
       maxnumber as (
           select max(number) as maxnum
           from enrollment
       )
       select * 
       from enrollment, maxnumber 
       where number = maxnum