Task: Text to Code
Input (English): find each value of dorm_name in Dorm table along with the number of the corresponding rows to each value
Output (English): SELECT dorm_name , Count ( * ) FROM Dorm GROUP BY dorm_name