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: Onde foram realizados os Jogos do Mediterrâneo?
 ###Tabelas: CREATE TABLE 2002 (2002_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Visiting Team VARCHAR, Final Score VARCHAR, Host Team VARCHAR, Stadium VARCHAR) CREATE TABLE cantonal_school_systems (cantonal_school_systems_id AUTO_INCREMENT PRIMARY KEY, Canton VARCHAR, Years of Kindergarten INT, Years of Kindergarten provided VARCHAR, Years of Kindergarten legally required VARCHAR, Length of Primary School INT, Length of mandatory Secondary School INT, Separate Secondary Schools? VARCHAR, Cooperative Secondary Schools? VARCHAR, Integrated Secondary Schools? VARCHAR) CREATE TABLE achievements (achievements_id AUTO_INCREMENT PRIMARY KEY, Year INT, Tournament VARCHAR, Venue VARCHAR, Result VARCHAR, Extra VARCHAR) CREATE TABLE by_season (by_season_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Race INT, Podium INT, Pole INT, FLap INT) CREATE TABLE week_4:_july_30_and_31_2008 (week_4:_july_30_and_31_2008_id AUTO_INCREMENT PRIMARY KEY, Main contestant VARCHAR, Co-contestant (Yaar vs. Pyaar) VARCHAR, Date performed VARCHAR, Scores by each individual judge VARCHAR, Total score/week VARCHAR, Position VARCHAR, Status VARCHAR)  
SELECT Venue FROM achievements WHERE Tournament = mediterranean games