What are the resolutions of all songs with a rating lower than 8?
select resolution from song where rating < 8
What are the IDs and resolutions of all the songs with resolutions higher than those?
select f_id,resolution from song where resolution > ( select max ( resolution ) from song where rating < 8 )
What are the IDs and resolutions of all the songs with resolutions higher than or equal to 1080?
select f_id,resolution from song where resolution > = 1080
What are the song names and ratings of those songs?
select song_name,rating from song where resolution > = 1080