Database: local_govt_and_lot
Question: What is the maximum number that a certain service is provided? List the service id, details and number.
SQL:
SELECT T1.service_id ,  T1.service_details ,  count(*) FROM Services AS T1 JOIN Residents_Services AS T2 ON T1.service_id  =  T2.service_id GROUP BY T1.service_id ORDER BY count(*) DESC LIMIT 1