Table: music_video_ranking
Columns: year
publication
country
accolade
rank

Question: What's the average year with a rank less than 3?
SQL: SELECT AVG("year") FROM music_video_ranking WHERE "rank" < 3

Question: What country got accolades in 2002?
SQL: SELECT "country" FROM music_video_ranking WHERE "year" = 2002

Question: What's the accolade for the rank of 497?
SQL: SELECT "accolade" FROM music_video_ranking WHERE "rank" = 497

Question: What's the average year for the accolade 100 greatest singles of all time?
SQL: SELECT AVG("year") FROM music_video_ranking WHERE "accolade" = '100 greatest singles of all time'