Table: evil_urges_2008
Columns: publication
country
accolade
year
rank

Question: Which year's rank was #4 when the country was the US?
SQL: SELECT "year" FROM evil_urges_2008 WHERE "rank" = '#4' AND "country" = 'us'

Question: Which publication happened in the UK?
SQL: SELECT "publication" FROM evil_urges_2008 WHERE "country" = 'uk'

Question: Which rank's country is the US when the accolade is 40 best albums of the year?
SQL: SELECT "rank" FROM evil_urges_2008 WHERE "country" = 'us' AND "accolade" = '40 best albums of the year'