What are the minimum, maximum and average values of the ratings?
select min(rating), max(rating), avg(rating) from song
Which songs have a higher rating than the average, list the song ids.
select f_id from song where rating > (select avg(rating) from song)
What about the song ids whose resolution is higher than the resolution of any songs with rating lower than 8?
select f_id from song where resolution > (select max(resolution) from song where rating < 8)