CREATE TABLE Residents_Services (service_id VARCHAR)
CREATE TABLE Services (service_id VARCHAR, service_details VARCHAR)

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 NULLS LAST LIMIT 1