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
list in descending order of the count refers to ORDER BY COUNT(*) DESC; count refers to COUNT(*); need to join two tables (Residents and Residents_Services) on resident_id;