Task: Text to Code
Input (English): Tell me the distinct block codes where some rooms are available.
Output (English): SELECT DISTINCT blockcode FROM room WHERE unavailable  =  0