List all the rooms that are available.
select * from room where unavailable = 0
What are the distinct block codes that have rooms available?
select distinct blockcode from room where unavailable = 0