CREATE TABLE artist (artist_name CLOB, country CLOB, gender CLOB, preferred_genre CLOB)
CREATE TABLE genre (g_name CLOB, rating CLOB, most_popular_in CLOB)
CREATE TABLE files (f_id NUMBER, artist_name CLOB, file_size CLOB, duration CLOB, formats CLOB)
CREATE TABLE song (song_name CLOB, artist_name CLOB, country CLOB, f_id NUMBER, genre_is CLOB, rating NUMBER, languages CLOB, releasedate TIME, resolution NUMBER)

What are the names and number of works for all artists who have sung at least one song in English?
SELECT T1.artist_name, COUNT(*) FROM artist AS T1 JOIN song AS T2 ON T1.artist_name = T2.artist_name WHERE T2.languages = "english" GROUP BY T2.artist_name HAVING COUNT(*) >= 1
SELECT "T1"."artist_name", COUNT(*) FROM "artist" "T1" JOIN "song" "T2" ON "T1"."artist_name" = "T2"."artist_name" AND "T2"."languages" = "english" GROUP BY "T2"."artist_name" HAVING COUNT(*) >= 1