Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Qual local tem um Kitmaker da lotto e uma equipe do apoel?
 ###Tabelas: CREATE TABLE overview (overview_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Head Coach VARCHAR, Team Captain VARCHAR, Venue VARCHAR, Capacity INT, Kitmaker VARCHAR, Shirt sponsor VARCHAR, Club Chairman VARCHAR) CREATE TABLE current_member_schools (current_member_schools_id AUTO_INCREMENT PRIMARY KEY, School VARCHAR, Location VARCHAR, Enrolment INT, Founded INT, Denomination VARCHAR, Boys/Girls VARCHAR, Day/Boarding VARCHAR, School Colors VARCHAR) CREATE TABLE 1960s_giants_12-6 (1960s_giants_12-6_id AUTO_INCREMENT PRIMARY KEY, Year INT, Date VARCHAR, Winner VARCHAR, Result VARCHAR, Loser VARCHAR, Location VARCHAR) CREATE TABLE eleventh_doctor_novels (eleventh_doctor_novels_id AUTO_INCREMENT PRIMARY KEY, Title VARCHAR, Author VARCHAR, Reader VARCHAR, Format VARCHAR, Company VARCHAR, Release Date VARCHAR, Notes VARCHAR) CREATE TABLE 2003_fedex_ground_winners (2003_fedex_ground_winners_id AUTO_INCREMENT PRIMARY KEY, Week INT, Player VARCHAR, Team VARCHAR, Opponent VARCHAR, Carries INT, Yards INT, Average VARCHAR, Touchdowns INT)  
SELECT Venue FROM overview WHERE Kitmaker = lotto AND Team = apoel