CREATE TABLE table_name_79 (school VARCHAR2, team_name VARCHAR2)

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"