Hello there!  How are you doing tonight!?  Can you provide me with a list of all of the artist names in this database?
select artist_name from artist
Thank you very much!  Can you filter that list to show only the artist_names who have song for which the country code is the UK?
select artist_name from artist where country = "UK" intersect select t1.artist_name from artist as t1 join song as t2 on t1.artist_name = t2.artist_name