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

Which team has coach John Kosmina?
SELECT "Team" FROM table_49657 WHERE "Coach" = 'john kosmina'
SELECT "Team" FROM "table_49657" WHERE "Coach" = 'john kosmina'