CREATE TABLE table_50902 ("Team" CLOB, "Coach" CLOB, "Home Ground" CLOB, "Location" CLOB, "Founded" CLOB)

Who is the coach of the team from Port Pirie?
SELECT "Coach" FROM table_50902 WHERE "Location" = 'port pirie'
SELECT "Coach" FROM "table_50902" WHERE "Location" = 'port pirie'