Database: music_1
Question: What is ids of the songs whose resolution is higher than the average resolution of songs in modern genre?
SQL:
SELECT f_id FROM song WHERE resolution  >  (SELECT avg(resolution) FROM song WHERE genre_is  =  "modern")