use raj
select bcode, bname
from BUILDING
where bname like '%SOUTH%';
select cap,layout,type,dept
from room
where bcode = 'CLSO' and rnumber = '206';
select rnumber
from room
where bcode = 'CLSO';
select count(rnumber)
from room
where bcode = 'CLSO';
select bcode BUILDING,count(rnumber) "NUM OF ROOMS"
from room
group by bcode;
select bname BUILDING,count(rnumber) "NUM OF ROOMS"
from room, building
where room.bcode = building.bcode
group by room.bcode;
(13) Get total number of seats in each building
select bcode,sum(cap)
from room
group by bcode;