List all the song names and the resolutions in ascending order of resolution.
select song_name, resolution from song order by resolution asc
Which ones are the top two of the resolution?
select song_name, resolution from song order by resolution desc limit 2
What is the average resolution for the English songs?
select avg(resolution) from song where languages = "english"
Which songs have a higher resolution than the English ones?
select song_name from song where resolution > (select min(resolution) from song where languages = "english")
What about the distinct song names of them?
select distinct song_name from song where resolution > (select min(resolution) from song where languages = "english")