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)
SELECT f_id FROM song WHERE resolution > (SELECT AVG(resolution) FROM song WHERE genre_is = "modern")
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE song (f_id VARCHAR, resolution INTEGER, genre_is VARCHAR) Question: What is ids of the songs whose resolution is higher than the average resolution of songs in modern genre? [/INST] SELECT f_id FROM song WHERE resolution > (SELECT AVG(resolution) FROM song WHERE genre_is = "modern") </s>