CREATE TABLE table_name_25 (school_club_team VARCHAR, player VARCHAR)

What team does Kenny Smith play for?
SELECT school_club_team FROM table_name_25 WHERE player = "kenny smith"
SELECT "school_club_team" FROM "table_name_25" WHERE "kenny smith" = "player"