Schema SQL Query SQL Results Edit on DB Fiddle
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