CREATE TABLE table_28243691_1 (team_nickname VARCHAR2, location VARCHAR2)

How many mascotts are there for college station, texas
SELECT COUNT(team_nickname) FROM table_28243691_1 WHERE location = "College Station, Texas"
SELECT COUNT("team_nickname") FROM "table_28243691_1" WHERE "College Station, Texas" = "location"