Which team has coach John Kosmina?
CREATE TABLE "south_australia" (
  "team" text,
  "coach" text,
  "home_ground" text,
  "location" text,
  "founded" real
);
SELECT "team" FROM "south_australia" WHERE "coach"='john kosmina';