CREATE TABLE table_55874 ("Player" CLOB, "Position" CLOB, "School" CLOB, "Hometown" CLOB, "College" CLOB)

Which player attended Hoover High School?
SELECT "Player" FROM table_55874 WHERE "School" = 'hoover high school'
SELECT "Player" FROM "table_55874" WHERE "School" = 'hoover high school'