Table schema:
CREATE TABLE room (blockcode VARCHAR, unavailable VARCHAR)

Question: What are the unique block codes that have available rooms?
SQL: SELECT DISTINCT blockcode FROM room WHERE unavailable = 0