Can you show me how many rooms are there in total?
select count ( * ) from room
How about the total number of block codes?
select count ( distinct blockcode ) from room
Yes
select blockcode from room order by roomnumber desc