CREATE TABLE table_26916717_1 (team_school VARCHAR, name VARCHAR)

Where did adrian smith go to college?
SELECT team_school FROM table_26916717_1 WHERE name = "Adrian Smith"
SELECT "team_school" FROM "table_26916717_1" WHERE "Adrian Smith" = "name"