Table: swimming_champs_2012_2
Columns: event
date
round
name
nationality
time
record

Question: Which event was Ye Shiwen in?
SQL: SELECT "event" FROM swimming_champs_2012_2 WHERE "name" = 'ye shiwen'

Question: Who had a time of 26.11?
SQL: SELECT "name" FROM swimming_champs_2012_2 WHERE "time" = '26.11'

Question: What was the date in which the time was 2:16.08?
SQL: SELECT "date" FROM swimming_champs_2012_2 WHERE "time" = '2:16.08'

Question: Who was in the women's 200m medley?
SQL: SELECT "name" FROM swimming_champs_2012_2 WHERE "event" = 'women''s 200m medley'

Question: What was the nationality of the swimmer in the semifinal with a time of 29.51?
SQL: SELECT "nationality" FROM swimming_champs_2012_2 WHERE "round" = 'semifinal' AND "time" = '29.51'