How many artists have recorded at least one song in English?
select count ( * ) from ( select * 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 are the names of the artists?
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
How many songs has Enrique recorded?
select count ( * ) from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t1.artist_name = "Enrique"
What about the other artist?
select count ( * ) from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t1.artist_name = ( select t1.artist_name from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t2.languages = "english" and t1.artist_name ! = "Enrique" group by t2.artist_name having count ( * ) > = 1 )