CREATE TABLE Salespersons (
id INT PRIMARY KEY,
name VARCHAR(50)
);
CREATE TABLE Sales (
salesperson_id INT,
product_id INT,
quantity INT,
sale_date DATE
);
INSERT INTO Salespersons (id, name) VALUES
(1, 'Salesperson1'),
(2, 'Salesperson2'),
(3, 'Salesperson3');
INSERT INTO Sales (salesperson_id, product_id, quantity, sale_date) VALUES
(1, 1, 10, '2023-01-15'),
(2, 1, 15, '2023-01-20'),
(3, 1, 20, '2023-01-25'),
(1, 1, 25, '2023-02-15'),
(2, 1, 30, '2023-02-20'),
(3, 1, 35, '2023-02-25');
-- Write a SQL query to identify the salesperson with the highest total quantity sold for each month.
-- Write your query below