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