CREATE TABLE table_1973648_1 (enrollment VARCHAR2, joined VARCHAR2)

Name the enrollment for 2007-08
SELECT enrollment FROM table_1973648_1 WHERE joined = "2007-08"
SELECT "enrollment" FROM "table_1973648_1" WHERE "2007-08" = "joined"