Table: eventing_results
Columns: nation
rider
horse
cross_country_penalties
total_penalties
total_team_penalties
team_rank

Question: Which nation is where rider phillip dutton from?
SQL: SELECT "nation" FROM eventing_results WHERE "rider" = 'Phillip Dutton'

Question: Which nation is where the horse parkmore ed is?
SQL: SELECT "nation" FROM eventing_results WHERE "horse" = 'Parkmore Ed'

Question: How many total team penalties are there when cross country penalties is 30.40?
SQL: SELECT "total_team_penalties" FROM eventing_results WHERE "cross_country_penalties" = '30.40'

Question: Who is the rider where the horse is galan de sauvagere?
SQL: SELECT "rider" FROM eventing_results WHERE "horse" = 'Galan De Sauvagere'

Question: How many penalties are there when Eric Vigeanel is the rider?
SQL: SELECT COUNT("total_penalties") FROM eventing_results WHERE "rider" = 'Eric Vigeanel'