By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| product_id | product_name | price |
|---|---|---|
| 1 | ramen | 100 |
| 2 | curry | 200 |
| 3 | sushi | 200 |
| customer_id | order_date | product_id |
|---|---|---|
| A | 2023-05-22 | 1 |
| A | 2023-05-22 | 1 |
| A | 2023-05-22 | 1 |
| A | 2023-05-22 | 2 |
| A | 2023-05-22 | 2 |
| A | 2023-05-22 | 3 |
| B | 2023-05-22 | 3 |
| B | 2023-05-22 | 3 |
| B | 2023-05-22 | 2 |
| B | 2023-05-22 | 2 |
| B | 2023-05-22 | 1 |
| B | 2023-05-22 | 1 |
| B | 2023-05-22 | 3 |
| C | 2023-05-22 | 1 |
| C | 2023-05-22 | 1 |
| C | 2023-05-22 | 1 |
| customer_id | product_name | Times_purchased |
|---|---|---|
| A | ramen | 3 |
| B | sushi | 3 |
| C | ramen | 3 |