What is the average rating of the Bangla songs?
select avg(rating) from song where languages = "bangla"
How about English songs?
select avg(rating) from song where languages = "english"
How many of them in total?
select count(*) from song where languages = "english"
What are the id, genre and artist name of these songs in the order of rating?
select f_id, genre_is, artist_name from song where languages = "english" order by rating