Table: york_city_2006_07
Columns: date
opponent
venue
result
attendance

Question: Name the date of st albans city for result of drew 0-0
SQL: SELECT "date" FROM york_city_2006_07 WHERE "opponent" = 'st albans city' AND "result" = 'drew 0-0'

Question: Name the venue for 15 august 2006
SQL: SELECT "venue" FROM york_city_2006_07 WHERE "date" = '15 august 2006'

Question: Name the most attendance for tamworth with home venue
SQL: SELECT MAX("attendance") FROM york_city_2006_07 WHERE "opponent" = 'tamworth' AND "venue" = 'home'

Question: Name the least attendance for 10 october 2006
SQL: SELECT MIN("attendance") FROM york_city_2006_07 WHERE "date" = '10 october 2006'