CREATE TABLE song (artist_name VARCHAR(255), languages VARCHAR(255)); CREATE TABLE artist (artist_name VARCHAR(255))
Find the names and number of works of all artists who have at least one English songs.
    
SQL: 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