Table: kirsten_wall_tourney_results
Columns: event
2007_08
2008_09
2009_10
2010_11

Question: What is the Event when DNP shows for 2007–08?
SQL: SELECT "event" FROM kirsten_wall_tourney_results WHERE "2007_08" = 'dnp'

Question: What is the 2008–09 when the 2009–10 shows q?
SQL: SELECT "2008_09" FROM kirsten_wall_tourney_results WHERE "2009_10" = 'q'

Question: What is the 2009–10 when the 2007–08 shows n/a, and an Event of colonial square ladies classic?
SQL: SELECT "2009_10" FROM kirsten_wall_tourney_results WHERE "2007_08" = 'n/a' AND "event" = 'colonial square ladies classic'

Question: What is the Event when the 2008–09 is sf?
SQL: SELECT "event" FROM kirsten_wall_tourney_results WHERE "2008_09" = 'sf'

Question: What is the 2010–11 when the Event is colonial square ladies classic?
SQL: SELECT "2010_11" FROM kirsten_wall_tourney_results WHERE "event" = 'colonial square ladies classic'

Question: What is the 2007–08 when the event was autumn gold?
SQL: SELECT "2007_08" FROM kirsten_wall_tourney_results WHERE "event" = 'autumn gold'