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 pintura foi exibida imediatamente antes de 'A Persistência da Memória' de Salvador Dali?
 ###Tabelas: 
CREATE TABLE painting_exhibitions (painting_id INT, exhibition_id INT, painting_title VARCHAR(255), exhibition_title VARCHAR(255), exhibition_start_date DATE); INSERT INTO painting_exhibitions (painting_id, exhibition_id, painting_title, exhibition_title, exhibition_start_date) VALUES (1, 5, 'The Persistence of Memory', 'Dali and Surrealism', '2026-01-01'); INSERT INTO painting_exhibitions (painting_id, exhibition_id, painting_title, exhibition_title, exhibition_start_date) VALUES (2, 6, 'Swans Reflecting Elephants', 'Dali and Optical Illusions', '2025-01-01');
SELECT painting_exhibitions.painting_id, painting_exhibitions.exhibition_id, painting_exhibitions.painting_title, painting_exhibitions.exhibition_title, painting_exhibitions.exhibition_start_date, LAG(painting_exhibitions.exhibition_start_date, 1) OVER (ORDER BY painting_exhibitions.exhibition_start_date DESC) as previous_exhibition_date FROM painting_exhibitions WHERE painting_exhibitions.painting_title = 'The Persistence of Memory';