What is ids of the songs whose resolution is higher than the average resolution of songs in modern genre?
CREATE TABLE song (f_id VARCHAR, resolution INTEGER, genre_is VARCHAR)
[SQL] SELECT f_id FROM song WHERE resolution > (SELECT AVG(resolution) FROM song WHERE genre_is = "modern") [/SQL]