CREATE TABLE artist (artist_name VARCHAR2, country VARCHAR2, languages VARCHAR2)
CREATE TABLE song (artist_name VARCHAR2, country VARCHAR2, languages VARCHAR2)

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