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
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
select t1 . artist_name , count ( * ) from artist as t1 join song as t2 on t1 . artist_name = t2 . artist_name where t2 . languages = value group by t2 . artist_name having count ( * ) > = value
Find the names and number of works of all artists who have at least one English songs .