Table: york_city_2006_07
Columns: date
opponent
venue
result
attendance

Question: Which opponent has unknown attendance, and lost 2-0?
SQL: SELECT "opponent" FROM york_city_2006_07 WHERE "attendance" = 'unknown' AND "result" = 'lost 2-0'

Question: What is the result from the Leeds United opponent?
SQL: SELECT "result" FROM york_city_2006_07 WHERE "opponent" = 'leeds united'

Question: What is the attendance rate for the Middlesbrough opponent?
SQL: SELECT "attendance" FROM york_city_2006_07 WHERE "opponent" = 'middlesbrough'