Table: australian_soccer_clubs_3
Columns: team
coach
home_ground
location
founded

Question: What is the location of South Adelaide?
SQL: SELECT "location" FROM australian_soccer_clubs_3 WHERE "team" = 'south adelaide'

Question: Which team has an unknown coach and location of Athelstone?
SQL: SELECT "team" FROM australian_soccer_clubs_3 WHERE "coach" = 'unknown' AND "location" = 'athelstone'

Question: When was the team that plays at Athelstone founded?
SQL: SELECT "founded" FROM australian_soccer_clubs_3 WHERE "location" = 'athelstone'

Question: Who is the coach of the team from Port Pirie?
SQL: SELECT "coach" FROM australian_soccer_clubs_3 WHERE "location" = 'port pirie'

Question: Who is the coach of the team with home ground at Club Cove?
SQL: SELECT "coach" FROM australian_soccer_clubs_3 WHERE "home_ground" = 'club cove'

Question: Which team was founded in 1970?
SQL: SELECT "team" FROM australian_soccer_clubs_3 WHERE "founded" = '1970'