CREATE TABLE table_name_79 (school VARCHAR(255), team_name VARCHAR(255))
What school has a team called the Pirates?
    
SQL: SELECT school FROM table_name_79 WHERE team_name = "pirates"