CREATE TABLE table_name_4 (school VARCHAR, team VARCHAR)

What school did the player drafted for the New York Mets attend?
SELECT school FROM table_name_4 WHERE team = "new york mets"
SELECT "school" FROM "table_name_4" WHERE "new york mets" = "team"