Hello there!  Can you provide me with a list of all of the service names?
select service_name from services
Thank you very much for that!  Could you please filter this list to show only the Service Names which occur more than once on the First Notification of Loss table?
select t2.service_name from first_notification_of_loss as t1 join services as t2 on t1.service_id = t2.service_id group by t1.service_id having count ( * ) > 1
My apologies!  I meant to ask for the list to be filtered to show only the Service Names which occur more than 2 times on the First_Notification_of_Loss table?
select t2.service_name from first_notification_of_loss as t1 join services as t2 on t1.service_id = t2.service_id group by t1.service_id having count ( * ) > 2
Awesome!  Can you show me how many times New policy application has been used?
select t2.service_name, count ( * ) from first_notification_of_loss as t1 join services as t2 on t1.service_id = t2.service_id group by t1.service_id having service_name = "New policy application"