SQL Medium | Interview Problem SQL Customers

DROP TABLE IF EXISTS Orders
CREATE TABLE Orders (
customer_name VARCHAR(255),
order_date DATETIME
);
INSERT INTO Orders (customer_name, order_date) VALUES ('Alice', '2024-04-01');
INSERT INTO Orders (customer_name, order_date) VALUES ('Bob', '2024-04-01');
INSERT INTO Orders (customer_name, order_date) VALUES ('Alice', '2024-04-02');
INSERT INTO Orders (customer_name, order_date) VALUES ('Bob', '2024-04-02');
INSERT INTO Orders (customer_name, order_date) VALUES ('Charlie', '2024-04-03');
INSERT INTO Orders (customer_name, order_date) VALUES ('Alice', '2024-04-03');
INSERT INTO Orders (customer_name, order_date) VALUES ('Alice', '2024-04-04');
INSERT INTO Orders (customer_name, order_date) VALUES ('Bob', '2024-04-04');
INSERT INTO Orders (customer_name, order_date) VALUES ('Charlie', '2024-04-05');
INSERT INTO Orders (customer_name, order_date) VALUES ('Alice', '2024-04-05');
INSERT INTO Orders (customer_name, order_date) VALUES ('Bob', '2024-04-06');
INSERT INTO Orders (customer_name, order_date) VALUES ('Charlie', '2024-04-06');
SELECT * FROM Orders order by customer_name;