How many services has each resident requested
SELECT T1.resident_id ,count ( * )  FROM Residents AS T1 JOIN Residents_Services AS T2 ON T1.resident_id   =   T2.resident_id GROUP BY T1.resident_id
count of services requested by each resident refers to COUNT(*); joining Residents with Residents_Services on resident_id to correlate residents with their requested services;