What are the unique block codes that have available rooms?
select distinct blockcode from room where unavailable = 0