What are all the different types of service details for things?
select distinct service_details from things
How many of each?
select count(*), service_details from things group by service_details
Show only the things with the detail being 'Unsatisfied'.
select * from things where service_details = 'Unsatisfied'
At how many distinct locations have they been located?
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'