CREATE TABLE artist (artist_name CLOB, country CLOB, gender CLOB, preferred_genre CLOB)
CREATE TABLE files (f_id NUMBER, artist_name CLOB, file_size CLOB, duration CLOB, formats CLOB)
CREATE TABLE genre (g_name CLOB, rating CLOB, most_popular_in CLOB)
CREATE TABLE song (song_name CLOB, artist_name CLOB, country CLOB, f_id NUMBER, genre_is CLOB, rating NUMBER, languages CLOB, releasedate TIME, resolution NUMBER)

What is ids of the songs whose resolution is higher than the average resolution of songs in 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" = "modern")