Table: charlton_athletics_2007_08
Columns: date
opponent
venue
result
attendance

Question: Which result has a Venue of away, and an Opponent of marbella?
SQL: SELECT "result" FROM charlton_athletics_2007_08 WHERE "venue" = 'away' AND "opponent" = 'marbella'

Question: Which venue has a Date of 28 july 2007?
SQL: SELECT "venue" FROM charlton_athletics_2007_08 WHERE "date" = '28 july 2007'

Question: What is the result with a home venue?
SQL: SELECT "result" FROM charlton_athletics_2007_08 WHERE "venue" = 'home'

Question: Which Date has a Result of 0–0?
SQL: SELECT "date" FROM charlton_athletics_2007_08 WHERE "result" = '0–0'

Question: Which date has a Result of 5–0, and an Opponent of tooting & mitcham?
SQL: SELECT "date" FROM charlton_athletics_2007_08 WHERE "result" = '5–0' AND "opponent" = 'tooting & mitcham'