human
Schema:
Customers (customer_id, customer_details)
Properties (property_id, property_type_code, property_address, other_details)
Residents (resident_id, property_id, date_moved_in, date_moved_out, other_details)
Organizations (organization_id, parent_organization_id, organization_details)
Services (service_id, organization_id, service_type_code, service_details)
Residents_Services (resident_id, service_id, date_moved_in, property_id, date_requested, date_provided, other_details)
Things (thing_id, organization_id, Type_of_Thing_Code, service_type_code, service_details)
Customer_Events (Customer_Event_ID, customer_id, date_moved_in, property_id, resident_id, thing_id)
Customer_Event_Notes (Customer_Event_Note_ID, Customer_Event_ID, service_type_code, resident_id, property_id, date_moved_in)
Timed_Status_of_Things (thing_id, Date_and_Date, Status_of_Thing_Code)
Timed_Locations_of_Things (thing_id, Date_and_Time, Location_Code)
Please answer with SQL.
assistant
Sure, I understand.
human
how many Services there
assistant
SELECT COUNT( * ) FROM Services;
human
what is the Check of service_id | Do you mean the service_id of all services with service_type_code 'Check'? | ok
assistant
SELECT service_id FROM Services WHERE service_type_code = "Check" ;