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