List the number of songs for each artist.
select t1.artist_name, count(*) from artist as t1 join song as t2 on t1.artist_name = t2.artist_name group by t2.artist_name
How many songs does Farida has?
select t1.artist_name, count(*) from artist as t1 join song as t2 on t1.artist_name = t2.artist_name group by t2.artist_name having t1.artist_name = 'Farida'
How about Prity?
select t1.artist_name, count(*) from artist as t1 join song as t2 on t1.artist_name = t2.artist_name group by t2.artist_name having t1.artist_name = 'Prity'
What about the people who has at least an English song?
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