Who is the coach of the team from Port Pirie?
CREATE TABLE table_name_6 (coach VARCHAR, location VARCHAR)
SELECT coach FROM table_name_6 WHERE location = "port pirie"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_6 (coach VARCHAR, location VARCHAR) Question: Who is the coach of the team from Port Pirie? [/INST] SELECT coach FROM table_name_6 WHERE location = "port pirie" </s>