SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE purchases (purchase_id INT, customer_id INT, purchase_date DATE ); INSERT INTO purchases VALUES (1, 101, '2024-01-01'); INSERT INTO purchases VALUES (2, 102, '2024-01-02'); INSERT INTO purchases VALUES (3, 101, '2024-01-02'); INSERT INTO purchases VALUES (4, 103, '2024-01-03'); INSERT INTO purchases VALUES (5, 101, '2024-01-03'); INSERT INTO purchases VALUES (6, 104, '2024-01-04'); INSERT INTO purchases VALUES (7, 102, '2024-01-04'); INSERT INTO purchases VALUES (8, 103, '2024-01-05'); INSERT INTO purchases VALUES (9, 102, '2024-01-05'); INSERT INTO purchases VALUES (10, 103, '2024-01-06'); INSERT INTO purchases VALUES (11, 102, '2024-01-06'); INSERT INTO purchases VALUES (12, 107, '2024-01-07'); select * from purchases; select *, dense_rank() over(partition by customer_id order by purchase_date ),day(purchase_date) from purchases order by purchase_id,purchase_date;