Table: australian_soccer_clubs_2
Columns: team
coach
home_ground
location
founded

Question: What is the average year that the club located in enfield was founded with an unknown coach?
SQL: SELECT AVG("founded") FROM australian_soccer_clubs_2 WHERE "coach" = 'unknown' AND "location" = 'enfield'

Question: What was the location of the club where the home ground is wilfred taylor reserve?
SQL: SELECT "location" FROM australian_soccer_clubs_2 WHERE "home_ground" = 'wilfred taylor reserve'

Question: Where is the club that was founded in 1946 located that has an unknown coach?
SQL: SELECT "location" FROM australian_soccer_clubs_2 WHERE "coach" = 'unknown' AND "founded" = 1946

Question: Where is the home ground for the club coached by nick pantsaras and founded before 1946?
SQL: SELECT "home_ground" FROM australian_soccer_clubs_2 WHERE "founded" < 1946 AND "coach" = 'nick pantsaras'