Bug Bounty 3: Sorting and order by

[tishyakhanna97]

Lab 3

• [x] Ensure order by works (no parser errors), and default order is asc
• [x] Ensure order by works for multiple columns select SId, Sname, GradYear from student order by GradYear asc, Sname desc
• [ ] Check costing of Sort Plan

[don-tay]

Test query

select sid,sname from student order by sname

select sid,sname from student order by sname desc

select SId, Sname, GradYear from student order by GradYear asc, Sname desc

Incorrect query:

select dname,count(sid) from student, dept where majorid=did group by dname order by dname desc

Running hash join
 dname countofsid
-----------------
compsci         7
drama         6
 math         4