What is ids of the songs whose resolution is higher than the resolution of any songs with rating lower than 8?
CREATE TABLE song (f_id VARCHAR, resolution INTEGER, rating INTEGER)
[SQL] SELECT f_id FROM song WHERE resolution > (SELECT MAX(resolution) FROM song WHERE rating < 8) [/SQL]