MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE pd_orders (
  `ordered_date` DATETIME,
  `order_code` VARCHAR(15),
  `customer_code` VARCHAR(14),
  `product_name` VARCHAR(10),
  `quantity` INTEGER
);

INSERT INTO pd_orders
  (`ordered_date`, `order_code`, `customer_code`, `product_name`, `quantity`)
VALUES
  ('2023/1/17', '662370230_FP_TW', '1676797_FP_TW', 'product_1', '10'),
  ('2023/1/17', '662370230_FP_TW', '1676797_FP_TW', 'product_2', '10'),
  ('2023/1/17', '662102654_FP_TW', '3794354_FP_TW', 'product_3', '8'),
  ('2023/1/17', '662513860_FP_TW', '3989950_FP_TW', 'product_4', '8'),
  ('2023/1/17', '662070842_FP_TW', '2384070_FP_TW', 'product_5', '5'),
  ('2023/1/17', '662097031_FP_TW', '8080834_FP_TW', 'product_6', '4'),
  ('2023/1/17', '662097031_FP_TW', '8080834_FP_TW', 'product_7', '4'),
  ('2023/1/17', '662025835_FP_TW', '1635359_FP_TW', 'product_8', '6'),
  ('2023/1/17', '662025835_FP_TW', '1635359_FP_TW', 'product_9', '4'),
  ('2023/1/17', '662025835_FP_TW', '1635359_FP_TW', 'product_10', '4'),
  ('2023/1/17', '662025835_FP_TW', '1635359_FP_TW', 'product_11', '4'),
  ('2023/1/17', '662177606_FP_TW', '4400774_FP_TW', 'product_12', '5'),
  ('2023/1/17', '662177606_FP_TW', '4400774_FP_TW', 'product_13', '5'),
  ('2023/1/17', '662177606_FP_TW', '4400774_FP_TW', 'product_14', '5'),
  ('2023/1/17', '662333911_FP_TW', '6798862_FP_TW', 'product_15', '4'),
  ('2023/1/17', '662333911_FP_TW', '6798862_FP_TW', 'product_16', '7'),
  ('2023/1/17', '662376770_FP_TW', '717440_FP_TW', 'product_17', '4'),
  ('2023/1/17', '662376770_FP_TW', '717440_FP_TW', 'product_18', '4'),
  ('2023/1/17', '662260058_FP_TW', '10822485_FP_TW', 'product_19', '4'),
  ('2023/1/17', '662260058_FP_TW', '10822485_FP_TW', 'product_20', '6'),
  ('2023/1/17', '662260058_FP_TW', '10822485_FP_TW', 'product_21', '5'),
  ('2023/1/17', '662201603_FP_TW', '2653694_FP_TW', 'product_22', '6');

Records: 22  Duplicates: 0  Warnings: 0

customer_code	product_name	quantity	order_rank
10822485_FP_TW	product_20	6	1
10822485_FP_TW	product_21	5	1
10822485_FP_TW	product_19	4	1
1635359_FP_TW	product_8	6	1
1635359_FP_TW	product_9	4	1
1635359_FP_TW	product_10	4	1
1635359_FP_TW	product_11	4	1
1676797_FP_TW	product_2	10	1
1676797_FP_TW	product_1	10	1
2384070_FP_TW	product_5	5	1
2653694_FP_TW	product_22	6	1
3794354_FP_TW	product_3	8	1
3989950_FP_TW	product_4	8	1
4400774_FP_TW	product_12	5	1
4400774_FP_TW	product_13	5	1
4400774_FP_TW	product_14	5	1
6798862_FP_TW	product_16	7	1
6798862_FP_TW	product_15	4	1
717440_FP_TW	product_17	4	1
717440_FP_TW	product_18	4	1
8080834_FP_TW	product_7	4	1
8080834_FP_TW	product_6	4	1