Table: ecco_tour_champ
Columns: year
venue
winner
country
score

Question: What is the Score, when the Year is after 2007, and when the Country is England?
SQL: SELECT "score" FROM ecco_tour_champ WHERE "year" > 2007 AND "country" = 'england'

Question: What is the latest Year, when the Venue is Lübker Golf Resort?
SQL: SELECT MAX("year") FROM ecco_tour_champ WHERE "venue" = 'lübker golf resort'

Question: What is the Score, when the Venue is Lübker Golf Resort?
SQL: SELECT "score" FROM ecco_tour_champ WHERE "venue" = 'lübker golf resort'

Question: What is the Venue, when the Winner is iain pyman?
SQL: SELECT "venue" FROM ecco_tour_champ WHERE "winner" = 'iain pyman'