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
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE room (blockcode VARCHAR, unavailable VARCHAR) Question: What are the unique block codes that have available rooms? [/INST] SELECT DISTINCT blockcode FROM room WHERE unavailable = 0 </s>