Tell me the distinct block codes where some rooms are available.
SELECT DISTINCT blockcode FROM room WHERE unavailable  =  0
distinct block codes refers to SELECT DISTINCT blockcode; some rooms are available refers to unavailable = 0;