What are the number of rooms for block code 1?
select count ( * ) from block as t1 join room as t2 on t1.blockfloor = t2.blockfloor and t1.blockcode = t2.blockcode where t1.blockcode = 1
What are the room numbers for Block Code 1?
select t2.roomnumber from block as t1 join room as t2 on t1.blockfloor = t2.blockfloor and t1.blockcode = t2.blockcode where t1.blockcode = 1
What is the block code for room 201?
select t1.blockcode from block as t1 join room as t2 on t1.blockfloor = t2.blockfloor and t1.blockcode = t2.blockcode where t2.roomnumber = 201
What is the room type for room 101?
select roomtype from room where roomnumber = 101