Table: baseball_clubs
Columns: club
sport
founded
league
venue

Question: Which venue was founded after 1967 and had the league North American Soccer League?
SQL: SELECT "venue" FROM baseball_clubs WHERE "founded" > 1967 AND "league" = 'north american soccer league'

Question: Which venue was fouded before 2000 for basketball?
SQL: SELECT "venue" FROM baseball_clubs WHERE "founded" < 2000 AND "sport" = 'basketball'

Question: Which club had football at Mitchel Athletic Field?
SQL: SELECT "club" FROM baseball_clubs WHERE "sport" = 'football' AND "venue" = 'mitchel athletic field'

Question: Which club was founded in 1962?
SQL: SELECT "club" FROM baseball_clubs WHERE "founded" = 1962