CREATE TABLE artist (artist_name VARCHAR(255), country VARCHAR(255), languages VARCHAR(255)); CREATE TABLE song (artist_name VARCHAR(255), country VARCHAR(255), languages VARCHAR(255))
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"