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: Quais são os 5 tópicos mais discutidos no último mês?
 ###Tabelas: 
CREATE TABLE posts (id INT, user_id INT, content TEXT, timestamp TIMESTAMP); INSERT INTO posts (id, user_id, content, timestamp) VALUES (1, 1, 'I love #programming', '2021-06-15 10:00:00'); INSERT INTO posts (id, user_id, content, timestamp) VALUES (2, 2, 'Just visited #Paris for the first time!', '2021-06-20 15:30:00'); CREATE TABLE topics (id INT, name VARCHAR(50)); INSERT INTO topics (id, name) VALUES (1, '#programming'); INSERT INTO topics (id, name) VALUES (2, '#travel'); INSERT INTO topics (id, name) VALUES (3, '#food'); INSERT INTO topics (id, name) VALUES (4, '#music'); INSERT INTO topics (id, name) VALUES (5, '#sports'); CREATE TABLE post_topics (post_id INT, topic_id INT); INSERT INTO post_topics (post_id, topic_id) VALUES (1, 1); INSERT INTO post_topics (post_id, topic_id) VALUES (2, 2);
SELECT topics.name, COUNT(post_topics.post_id) AS post_count FROM topics INNER JOIN post_topics ON topics.id = post_topics.topic_id WHERE post_topics.post_id IN (SELECT id FROM posts WHERE timestamp >= DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 MONTH)) GROUP BY topics.name ORDER BY post_count DESC LIMIT 5;