Find the names and number of works of all artists who have at least one English songs.
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
names of artists with at least one English song = SELECT artist_name FROM artist JOIN song ON artist.artist_name = song.artist_name WHERE song.languages = 'english'; number of works = count(*) GROUP BY artist_name; artists who have at least one English song = HAVING count(*) >= 1;