How many songs are produced by male artists?
select count(*) from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t1.gender = "Male"
How about female artisits?
select count(*) from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t1.gender = "Female"
Among those songs, which ones are in Bangla?
select count(*) from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t1.gender = "Female" and languages = "bangla"
What are the country of origin for the artists of these songs?
select t1.country from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t1.gender = "Female" and t2.languages = "bangla"