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