What are the minimum, maximum and average values of the resolution?
select min(resolution), max(resolution), avg(resolution) from song
Which songs have a higher value than the average, list the song ids.
select f_id from song where resolution > (select avg(resolution) from song)
How about the ones that is higher than the average resolution value for the modern genre songs?
select f_id from song where resolution > (select avg(resolution) from song where genre_is = "modern")