CREATE TABLE room (blockcode VARCHAR(255), unavailable VARCHAR(255))
What are the unique block codes that have available rooms?
    
SQL: SELECT DISTINCT blockcode FROM room WHERE unavailable = 0