How many residential services were requested?
select count(*) from residents_services
How about for each resident?
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
Also show the other details for each resident.
select t1.resident_id, t1.other_details, count(*) from residents as t1 join residents_services as t2 on t1.resident_id = t2.resident_id group by t1.resident_id
Order the previous table in descending order of the number of requests.
select t1.resident_id, t1.other_details, count(*) from residents as t1 join residents_services as t2 on t1.resident_id = t2.resident_id group by t1.resident_id order by count(*) desc