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: Liste todas as rotas com mais de 50 remessas nos últimos 30 dias.
 ###Tabelas: 
CREATE TABLE Routes (route_id INT, origin VARCHAR(50), destination VARCHAR(50)); CREATE TABLE Shipments (shipment_id INT, route_id INT, shipment_date DATE); INSERT INTO Routes (route_id, origin, destination) VALUES (1, 'Seattle', 'Chicago'); INSERT INTO Shipments (shipment_id, route_id, shipment_date) VALUES (1, 1, '2021-04-15'); INSERT INTO Shipments (shipment_id, route_id, shipment_date) VALUES (2, 1, '2021-04-16');
SELECT Routes.* FROM Routes INNER JOIN (SELECT route_id, COUNT(*) as shipment_count FROM Shipments WHERE shipment_date BETWEEN DATEADD(day, -30, GETDATE()) AND GETDATE() GROUP BY route_id) as ShipmentCounts ON Routes.route_id = ShipmentCounts.route_id WHERE ShipmentCounts.shipment_count > 50;