Table: ghost_colours_albums
Columns: publication
country
accolade
year
rank

Question: Which accolade has USA as the country, with a year less than 2009?
SQL: SELECT "accolade" FROM ghost_colours_albums WHERE "country" = 'usa' AND "year" < 2009

Question: How many years have an accolade of 50 best albums of the year, with #3 as the rank?
SQL: SELECT SUM("year") FROM ghost_colours_albums WHERE "accolade" = '50 best albums of the year' AND "rank" = '#3'

Question: Which rank has canada as the country?
SQL: SELECT "rank" FROM ghost_colours_albums WHERE "country" = 'canada'