Table: jeremy_video_rankings
Columns: publication
country
accolade
year
rank

Question: What is the sum of Year, when Rank is less than 19?
SQL: SELECT SUM("year") FROM jeremy_video_rankings WHERE "rank" < 19

Question: What is the sum of Year, when Publication is "VH1", and when Rank is greater than 11?
SQL: SELECT SUM("year") FROM jeremy_video_rankings WHERE "publication" = 'vh1' AND "rank" > 11

Question: What is Accolade, when Year is less than 2002, when Publication is "Rolling Stone", and when Rank is "48"?
SQL: SELECT "accolade" FROM jeremy_video_rankings WHERE "year" < 2002 AND "publication" = 'rolling stone' AND "rank" = 48

Question: What is the lowest Year, when Rank is greater than 85?
SQL: SELECT MIN("year") FROM jeremy_video_rankings WHERE "rank" > 85

Question: What is Accolade, when Country is "United States", and when Year is "1999"?
SQL: SELECT "accolade" FROM jeremy_video_rankings WHERE "country" = 'united states' AND "year" = 1999