Table: cypriot_football_club
Columns: team
head_coach
team_captain
venue
capacity
kitmaker
shirt_sponsor
club_chairman

Question: Which Team has a Head Coach of michalis pamboris?
SQL: SELECT "team" FROM cypriot_football_club WHERE "head_coach" = 'michalis pamboris'

Question: What is umbro's highest capacity?
SQL: SELECT MAX("capacity") FROM cypriot_football_club WHERE "kitmaker" = 'umbro'

Question: Which Venue has a Kitmaker of lotto, and a Team of apoel?
SQL: SELECT "venue" FROM cypriot_football_club WHERE "kitmaker" = 'lotto' AND "team" = 'apoel'