Table: football_clubs
Columns: club
location
manager
venue
capacity

Question: What is the highest capacity for the venue, ticha stadium, located in varna?
SQL: SELECT MAX("capacity") FROM football_clubs WHERE "location" = 'varna' AND "venue" = 'ticha stadium'

Question: What is the highest capacity for the venue of the club, vihren?
SQL: SELECT MAX("capacity") FROM football_clubs WHERE "club" = 'vihren'

Question: What is the total number of capacity for the venue of the club, pirin?
SQL: SELECT COUNT("capacity") FROM football_clubs WHERE "club" = 'pirin'