Table: canoe_2008_men_c1
Columns: rank
athletes
country
time
notes

Question: What are the notes for the athlete from South Africa?
SQL: SELECT "notes" FROM canoe_2008_men_c1 WHERE "country" = 'south africa'

Question: What are the notes for the athlete from Spain?
SQL: SELECT "notes" FROM canoe_2008_men_c1 WHERE "country" = 'spain'

Question: What is Calvin Mokoto's average rank?
SQL: SELECT AVG("rank") FROM canoe_2008_men_c1 WHERE "athletes" = 'calvin mokoto'

Question: What is Andreas Kiligkaridis rank?
SQL: SELECT "rank" FROM canoe_2008_men_c1 WHERE "athletes" = 'andreas kiligkaridis'