Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE residents_services ( resident_id number, service_id number, date_moved_in time, property_id number, date_requested time, date_provided time, other_details text )
TABLE: CREATE TABLE services ( service_id number, organization_id number, service_type_code text, service_details text )
TABLE: CREATE TABLE customers ( customer_id number, customer_details text )
TABLE: CREATE TABLE organizations ( organization_id number, parent_organization_id number, organization_details text )
TABLE: CREATE TABLE properties ( property_id number, property_type_code text, property_address text, other_details text )
TABLE: CREATE TABLE timed_locations_of_things ( thing_id number, date_and_time time, location_code text )
TABLE: CREATE TABLE customer_event_notes ( customer_event_note_id number, customer_event_id number, service_type_code text, resident_id number, property_id number, date_moved_in time )
TABLE: CREATE TABLE residents ( resident_id number, property_id number, date_moved_in time, date_moved_out time, other_details text )
TABLE: CREATE TABLE things ( thing_id number, organization_id number, type_of_thing_code text, service_type_code text, service_details text )
TABLE: CREATE TABLE customer_events ( customer_event_id number, customer_id number, date_moved_in time, property_id number, resident_id number, thing_id number )
TABLE: CREATE TABLE timed_status_of_things ( thing_id number, date_and_date time, status_of_thing_code text )

### Question ###
What is the maximum number that a certain service is provided? List the service id, details and number.

### Accurate 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