Table schema:
CREATE TABLE table_name_6 (coach VARCHAR, location VARCHAR)

Question: Who is the coach of the team from Port Pirie?
SQL: SELECT coach FROM table_name_6 WHERE location = "port pirie"