Table: olympic_athlete
Columns: medal
name
games
sport
event

Question: What is the names for the medalist in the sport of canoeing?
SQL: SELECT "name" FROM olympic_athlete WHERE "sport" = 'canoeing'

Question: What games had the women's half middleweight event?
SQL: SELECT "games" FROM olympic_athlete WHERE "event" = 'women''s half middleweight'

Question: Who received the bronze medal in the 2000 Sydney games?
SQL: SELECT "name" FROM olympic_athlete WHERE "medal" = 'bronze' AND "games" = '2000 sydney'