By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 9
| order_id | status_update | status_date | order_id |
|---|---|---|---|
| A | Received | 2020-01-01 | A |
| A | Pending | 2020-01-15 | A |
| A | Processing | 2020-01-07 | A |
| A | Delivered | 2020-01-15 | A |
| C | Received | 2020-02-15 | C |
| C | Delivered | 2020-02-20 | C |
SELECT 6