What are the names of the top 3 artists with the largest number of songs?
select t1.artist_name from artist as t1 join song as t2 on t1.artist_name = t2.artist_name group by t2.artist_name order by count ( * ) desc limit 3
What about the top 3 artists with the largest number of songs whose language is Bangla?
select t1.artist_name from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t2.languages = "bangla" group by t2.artist_name order by count ( * ) desc limit 3
What are their preferred genres?
select t1.preferred_genre from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t2.languages = "bangla" group by t2.artist_name order by count ( * ) desc limit 3
Could you list the names of all artists that prefer the genre folk and speak the language Bangla?
select t1.artist_name from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t2.languages = "bangla" and t1.preferred_genre = "folk"
How about the names of all artists that prefer the genre folk?
select artist_name from artist where preferred_genre = "folk"
How about the names of all artists that prefer the genre tagore?
select artist_name from artist where preferred_genre = "tagore"