Table: mike_spracklen_olympic_medal
Columns: year
championship
event
nation
result

Question: What year was olympics, Canada and the Men's Eight Event ended with a silver medal?
SQL: SELECT MAX("year") FROM mike_spracklen_olympic_medal WHERE "championship" = 'olympics' AND "event" = 'men''s eight' AND "nation" = 'canada' AND "result" = 'silver'

Question: What event was in 2006?
SQL: SELECT "event" FROM mike_spracklen_olympic_medal WHERE "year" = 2006

Question: What championship was in the USA after 1994, and resulted in 5th place?
SQL: SELECT "championship" FROM mike_spracklen_olympic_medal WHERE "nation" = 'usa' AND "year" > 1994 AND "result" = '5th'

Question: What year did Canada get a silver in the olympics in the Men's Coxless Pair event?
SQL: SELECT MIN("year") FROM mike_spracklen_olympic_medal WHERE "nation" = 'canada' AND "result" = 'silver' AND "championship" = 'olympics' AND "event" = 'men''s coxless pair'