What language is used most often in songs?
select languages from song group by languages order by count ( * ) desc limit 1
And what is the range of resolution in songs?
select min ( resolution ), max ( resolution ) from song
What is the range of ratings for those songs?
select min ( rating ), max ( rating ) from song
What is the language most often used in songs with resolution below 500?
select languages from song where resolution < 500 group by languages order by count ( * ) desc limit 1
And what language is most often used in songs with resolution above 500?
select languages from song where resolution > 500 group by languages order by count ( * ) desc limit 1