Database: music_1
Question: Find the names of the artists who are from UK and have produced English songs.
SQL:
SELECT artist_name FROM artist WHERE country  =  "UK" INTERSECT SELECT artist_name FROM song WHERE languages  =  "english"