Table: athletes_results_3
Columns: year
tournament
venue
result
extra

Question: What is the total number of years wehre anna thompson had a 3rd place result at edinburgh, scotland?
SQL: SELECT COUNT("year") FROM athletes_results_3 WHERE "result" = '3rd' AND "venue" = 'edinburgh, scotland'

Question: What year did anna thompson have a 7th place result?
SQL: SELECT "year" FROM athletes_results_3 WHERE "result" = '7th'

Question: What is the average year that anna thompson had an 8th place result in team competition at the world cross country championships in st etienne, france with
SQL: SELECT AVG("year") FROM athletes_results_3 WHERE "tournament" = 'world cross country championships' AND "venue" = 'st etienne, france' AND "extra" = 'team competition' AND "result" = '8th'