select count(*) from classroom;
19
select count(*) from FACULTY where deptid='SIT';
7
select semester from whenoffered where crscode='COMP5138';
s1 s2
select c.crscode,c.classroomid, d.seats, d.type from courseoffering c, classroom d where c.classroomid = d.classroomid;

select f.name from faculty f, courseoffering c where c.crscode='INFO3005' AND c.instructorid = f.id AND c.year=2005;
geoff kennedy

select count(*) from courseoffering c, faculty f WHERE f.name='Sanjay Chawla' AND c.year='2006';
7

select s.name from student s, transcript t WHERE t.crscode='info2120' AND t.studid = s.id;

select crscode,classroomid from courseoffering where classroomid like 'CAR%';
3

select crscode,classroomid from courseoffering where classroomid like 'CAR%' AND year='2006' and semester='S2';
2