SELECT f_id FROM song WHERE resolution  >  (SELECT avg(resolution) FROM song WHERE genre_is  =  "modern")
What are the ids of all songs that have higher resolution of the average resolution in the modern genre?
SELECT f_id FROM song WHERE resolution > ( SELECT avg ( resolution ) FROM song WHERE genre_is = `` modern '' )
select f_id from song where resolution > ( select avg ( resolution ) from song where genre_is = value )
What are the ids of all songs that have higher resolution of the average resolution in the modern genre ?