--sample solution for exercises 1-5 CONNECT TO SE3DB3; --Exercise 1 SELECT name FROM STUDENT WHERE dept_name = 'Comp. Sci.' AND tot_cred >55; --Exercise 2 SELECT course_id, grade FROM student, takes WHERE name='Zhang' AND student.id=takes.id; --Exercise 3 SELECT title FROM COURSE WHERE credits > ANY (SELECT credits FROM COURSE WHERE dept_name='Biology'); --Exercise 4 SELECT name FROM STUDENT WHERE tot_cred >= ALL (SELECT tot_cred FROM student); --Alternative solution if using max command SELECT NAME FROM STUDENT WHERE TOT_CRED IN (SELECT MAX(TOT_CRED) FROM STUDENT); --Exercise 5 SELECT DISTINCT id FROM TAKES WHERE course_id IN(SELECT course_id FROM course WHERE dept_name = 'Comp. Sci.') AND year=2010; TERMINATE;