CREATE TABLE table_204_590 (id NUMBER, "year" NUMBER, "division" NUMBER, "league" CLOB, "regular season" CLOB, "playoffs" CLOB, "open cup" CLOB, "avg. attendance" NUMBER)

what is the average number of attendance in 2007 ?
SELECT "avg. attendance" FROM table_204_590 WHERE "year" = 2007
SELECT "avg. attendance" FROM "table_204_590" WHERE "year" = 2007