What is ids of the songs whose resolution is higher than the resolution of any songs with rating lower than 8?
SELECT f_id FROM song WHERE resolution  >  (SELECT max(resolution) FROM song WHERE rating  <  8)
ids of the songs = f_id; resolution higher than = resolution >; resolution of any songs with rating lower than 8 = max(resolution) from song where rating < 8;