Table: leeds_200708_season
Columns: match
date
competition_or_tour
ground
opponent
score1

Question: What is the Score1 of Match 42?
SQL: SELECT "score1" FROM leeds_200708_season WHERE "match" = 42

Question: On what date was the match higher than 8 on ground A against Guiseley?
SQL: SELECT "date" FROM leeds_200708_season WHERE "match" > 8 AND "ground" = 'a' AND "opponent" = 'guiseley'

Question: On what ground was the game on 31 Jul 2007?
SQL: SELECT "ground" FROM leeds_200708_season WHERE "date" = '31 jul 2007'