CREATE TABLE table_name_79 (school VARCHAR, team_name VARCHAR)

What school has a team called the Pirates?
SELECT school FROM table_name_79 WHERE team_name = "pirates"
SELECT "school" FROM "table_name_79" WHERE "pirates" = "team_name"