What was the attendance when the opponent was virginia?
CREATE TABLE table_7067 (
    "Date" text,
    "Opponent" text,
    "Location" text,
    "Result" text,
    "Attendance" real
)
SELECT SUM("Attendance") FROM table_7067 WHERE "Opponent" = 'virginia'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What was the attendance when the opponent was virginia? ### Input: CREATE TABLE table_7067 (
    "Date" text,
    "Opponent" text,
    "Location" text,
    "Result" text,
    "Attendance" real
) ### Response: SELECT SUM("Attendance") FROM table_7067 WHERE "Opponent" = 'virginia'