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