Issues
- 0
- 1
select distinct gradyear, majorid, count(sid) from student, dept where sid >= 1 and majorid = did group by gradyear, majorid, did order by gradyear asc, majorid desc, count(sid) desc
#12 opened by tjwjoe - 1
select count(sid), majorid from student where count(sid) = 2 group by majorid
#16 opened by LimZeWeiDennis - 0
select sname, gradyear, sid, eid, dname from student, enroll, dept where studentid = sid and did = majorid
#14 opened by tjwjoe - 0
Calculating Cost of join plan
#13 opened by LimZeWeiDennis - 0