Task: Text to Code
Input (English): Step 1: For each row in artist table, find the corresponding rows in song table.
Step 2: find artist's artist_name of the results of step 1 whose song's country equals UK.
Step 3: find artist's artist_name of the results of step 1 whose song's country equals english.
Step 4: show the rows that are in both the results of step 2 and the results of step 3
Output (English): SELECT T1.artist_name FROM artist AS T1 JOIN song AS T2 ON T1.artist_name = T2.artist_name WHERE T2.country = "UK" INTERSECT SELECT T1.artist_name FROM artist AS T1 JOIN song AS T2 ON T1.artist_name = T2.artist_name WHERE T2.country = "english"