I need to know the names of artists with at least one English Song
select t1.artist_name 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
What is the country of origin of artists with at least one English song
select t1.country from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t2.languages = 'english' group by t1.artist_name having count ( * ) > = 1
What is the gender of artists with at least one English song?
select t1.gender from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t2.languages = 'english' group by t1.artist_name having count ( * ) > = 1
What is the rating of artists with at least one English song?
select t2.rating from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t2.languages = 'english' group by t1.artist_name having count ( * ) > = 1