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