What are the resolutions of all songs with a rating lower than 8?
SELECT resolution FROM song WHERE rating  <  8
rating lower than 8 refers to rating < 8; resolutions of songs refers to resolution field;