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  =  0
[{'BlockCode': 1}, {'BlockCode': 2}, {'BlockCode': 3}]