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