What are the IDs and resolutions of all the songs with resolutions higher than those?
SELECT f_id,resolution FROM song WHERE resolution  >   ( SELECT max ( resolution )  FROM song WHERE rating  <  8 ) 
IDs and resolutions of all the songs with resolutions higher refers to SELECT f_id, resolution FROM song; resolutions higher than those with rating less than 8 refers to WHERE resolution > (SELECT MAX(resolution) FROM song WHERE rating < 8);