SELECT DISTINCT blockcode FROM room WHERE unavailable  =  0
Tell me the distinct block codes where some rooms are available.
SELECT DISTINCT blockcode FROM room WHERE unavailable = 0
select distinct blockcode from room where unavailable = value
Tell me the distinct block codes where some rooms are available .