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
select sid,sname,dname,grade from student,dept,enroll where sid=studentid and majorid=did
select sid,sname,eid,sectid from student, enroll, section where sid=studentid and sectionid=sectid
select distinct did, title, prof from dept, course, section where did=deptid and cid=courseid order by prof
select distinct sid,sname,dname,title,grade from student,dept,course,enroll where sid=studentid and deptid=did and majorid=did and sectionid = sectid
select sid,sname,dname,title,grade from student,dept,course,enroll where sid=studentid and deptid=did and majorid=did
select dname,count(sid) from student, dept where majorid=did group by dname order by dname desc