What are the unique block codes that have available rooms?
SELECT DISTINCT blockcode FROM room WHERE unavailable  =  0
unique block codes = SELECT DISTINCT blockcode; available rooms refers to unavailable = 0;