Table: album_rankings
Columns: publication
country
accolade
year
rank

Question: What is the highest Year, when Rank is less than 28, and when Accolade is "The 100 greatest metal albums of the decade"?
SQL: SELECT MAX("year") FROM album_rankings WHERE "rank" < 28 AND "accolade" = 'the 100 greatest metal albums of the decade'

Question: What is Accolade, when Year is less than 2009, and when Country is Germany?
SQL: SELECT "accolade" FROM album_rankings WHERE "year" < 2009 AND "country" = 'germany'

Question: What is the highest Rank, when Publication is Dagsavisen, and when Year is less than 2005?
SQL: SELECT MAX("rank") FROM album_rankings WHERE "publication" = 'dagsavisen' AND "year" < 2005