Table: football_clubs_2
Columns: club
location
stadium
capacity
manager
kitmaker

Question: What is the stadium in Kuopio?
SQL: SELECT "stadium" FROM football_clubs_2 WHERE "location" = 'Kuopio'

Question: Who is the kitmaker for TPS?
SQL: SELECT "kitmaker" FROM football_clubs_2 WHERE "club" = 'TPS'

Question: What is the largest capacity for a stadium?
SQL: SELECT MAX("capacity") FROM football_clubs_2

Question: Which stadium is managed by Kari Martonen?
SQL: SELECT "stadium" FROM football_clubs_2 WHERE "manager" = 'Kari Martonen'

Question: How many capacities are given for FF Jaro club?
SQL: SELECT COUNT("capacity") FROM football_clubs_2 WHERE "club" = 'FF Jaro'

Question: How many managers for club in Turku where kitmaker is Puma?
SQL: SELECT COUNT("manager") FROM football_clubs_2 WHERE "kitmaker" = 'Puma' AND "location" = 'Turku'