CREATE TABLE table_name_6 (coach VARCHAR(255), location VARCHAR(255))
Who is the coach of the team from Port Pirie?
    
SQL: SELECT coach FROM table_name_6 WHERE location = "port pirie"