List all the song names by the resolution in ascending order.
select song_name from song order by resolution desc
How many songs have resolution higher than 800?
select count(song_name) from song where resolution > 800
What about lower?
select count(song_name) from song where resolution < 800
What are the file size and format of them?
select distinct t1.file_size, t1.formats from files as t1 join song as t2 on t1.f_id = t2.f_id where t2.resolution < 800