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
How many services has each resident requested? List the resident id, details, and the count in descending order of the count.
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
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
How many services has each resident requested ? List the resident id , details , and the count in descending order of the count .