How to find all the customers who placed orders on three consecutive days | SQL Scenario questions

 DML Script:

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

Detailed explanation: https://youtu.be/rR3eKS8jtfw