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
What is the maximum number that a certain service is provided? List the service id, details and number.
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
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 value
What is the maximum number that a certain service is provided ? List the service id , details and number .