SELECT DISTINCT blockcode FROM room WHERE unavailable  =  0
What are the unique block codes that have available rooms?
SELECT DISTINCT blockcode FROM room WHERE unavailable = 0
select distinct blockcode from room where unavailable = value
What are the unique block codes that have available rooms ?