Table: olympic_canoe_2008
Columns: rank
athletes
country
time
notes

Question: What is the average rank for Hungary?
SQL: SELECT AVG("rank") FROM olympic_canoe_2008 WHERE "country" = 'hungary'

Question: What country has a time of 3:19.167?
SQL: SELECT "country" FROM olympic_canoe_2008 WHERE "time" = '3:19.167'

Question: What are the notes for the time at 3:19.167?
SQL: SELECT "notes" FROM olympic_canoe_2008 WHERE "time" = '3:19.167'