List each language and how many songs for each?
select languages, count(*) from song group by languages
Which one is the most popular language?
select languages, count(*) from song group by languages desc limit 1
What about that for the songs which resolution are above 1000?
select artist_name from song where resolution > 1000 group by languages order by count(*) desc limit 1
How about resolution are above 500?
select artist_name from song where resolution > 500 group by languages order by count(*) desc limit 1