CREATE TABLE table_name_37 (venue VARCHAR, kitmaker VARCHAR, team VARCHAR)

Which Venue has a Kitmaker of lotto, and a Team of apoel?
SELECT venue FROM table_name_37 WHERE kitmaker = "lotto" AND team = "apoel"
SELECT "venue" FROM "table_name_37" WHERE "apoel" = "team" AND "kitmaker" = "lotto"