Table: euro_orienteering_champs
Columns: year
gold
silver
bronze
notes

Question: What is Notes, when Gold is "Thierry Gueorgiou", when Year is before 2008, and when Bronze is "Valentin Novikov"?
SQL: SELECT "notes" FROM euro_orienteering_champs WHERE "gold" = 'thierry gueorgiou' AND "year" < 2008 AND "bronze" = 'valentin novikov'

Question: What is Notes, when Silver is "Jarkko Huovila"?
SQL: SELECT "notes" FROM euro_orienteering_champs WHERE "silver" = 'jarkko huovila'

Question: What is the total number of Year, when Bronze is "Jamie Stevenson"?
SQL: SELECT COUNT("year") FROM euro_orienteering_champs WHERE "bronze" = 'jamie stevenson'

Question: What is Notes, when Bronze is "Pasi Ikonen"?
SQL: SELECT "notes" FROM euro_orienteering_champs WHERE "bronze" = 'pasi ikonen'

Question: What is Bronze, when Notes is "6.7km, 22controls"?
SQL: SELECT "bronze" FROM euro_orienteering_champs WHERE "notes" = '6.7km, 22controls'

Question: What is Silver, when Notes is "6.24km, 23controls"?
SQL: SELECT "silver" FROM euro_orienteering_champs WHERE "notes" = '6.24km, 23controls'