218.    Use your view get a list get a list of all classes (by coursename) that have been taught in ‘COBA’ room ‘301’, when they were taught (by semester name) and who the instructor was for the course

 

NOTE: Once again, because the output tends to look a little sloppy, I spooled the output and did some reformatting

 

 

SQL> select distinct classid, coursename, roomnum,

  2  semname, instname

  3  from course_enrollment

  4  where (buildname = 'COBA' and roomnum = '301')

  5  order by semname;

 

CLASSID COURSENAME           ROOMNUM    SEMNAME    INSTNAME

------- -------------------- ---------- ---------- ---------                 

   5000 Database             301        Fall 2002  Kirs

   5002 Database             301        Fall 2002  Kirs

 

SQL>