How many distinct locations have the things with service detail 'Unsatisfied' been located in?
select count ( distinct t2.location_code ) from things as t1 join timed_locations_of_things as t2 on t1.thing_id = t2.thing_id where t1.service_details = 'Unsatisfied'
Yes
select count ( distinct thing_id ) from things where type_of_thing_code = "Electronics"
What are the service details of thing id 2?
select service_details from things where thing_id = 2
What is the service type code of thing id 2?
select service_type_code from things where thing_id = 2
What is the location code of thing id 10 and the date and time?
select location_code, date_and_time from timed_locations_of_things where thing_id = 10