CS348 Lecture : Assignment #1 - Solution Fall 2009

• School: University of Waterloo
• Department: Computer Science
• Course: CS348
• Professor: Ihab Ilyas

Document Summary

Where p. pnum=c. pnum and c. cnum=s. cnum and c. term=s. term and c. section=s. section and s. day="tuesday" and c. term not in (select term from mark) Select count (distinct p. pnum) as past cs348 instructors. Where p. pnum=c. pnum and c. cnum="cs348" and c. term in (select term from mark) From enrollment e, mark m, student s, class c, course co. Join class c on m. cnum = c. cnum and m. term = c. term. Where m. grade < 92 and p. dept <> "philosophy". Where c. pnum=p. pnum and c. cnum=s. cnum and c. term=s. term and c. section=s. section and c. term not in (select term from mark) and (day="monday" or day ="friday") Where p. pnum=c. pnum and c. term in (select term from mark) Select cnum,count(*) cnt from enrollment group by cnum. Where not exists (select * from enrollment e where e. cnum = c. cnum) Select e. snum as snum, e. cnum as cnum, e. term as term, And e. term not in ( select distinct m. term from mark m ) Select p. pnum, p. pname, c. cnum, c. term, c. section, count (*) Where p. pnum =c. pnum and c. cnum = e. cnum and e. term = c. term.