MySQL 8.0

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

CREATE TABLE request_buys
    (`id` varchar(2), `invoice` varchar(17), `user_id` varchar(7))
;
    
INSERT INTO request_buys
    (`id`, `invoice`, `user_id`)
VALUES
    ('--', '-----------------', '-------'),
    ('3', '20220405/01104298', '1')
;

CREATE TABLE traces
    (`id` varchar(2), `request_buy_id` varchar(14), `status_id` varchar(9), `created_at` date)
;
    
INSERT INTO traces
    (`id`, `request_buy_id`, `status_id`, `created_at`)
VALUES
    ('37', '3', '1', '2022-03-27 14:12:25'),
    ('38', '3', '2', '2022-03-28 14:12:25'),
    ('39', '3', '3', '2022-03-29 14:12:25'),
    ('40', '3', '4', '2022-03-30 14:12:25'),
    ('41', '3', '5', '2022-03-31 14:12:25'),
    ('42', '3', '6', '2022-04-01 14:12:25')
;

CREATE TABLE statuses
    (`id` varchar(2), `nama` varchar(17))
;
    
INSERT INTO statuses
    (`id`, `nama`)
VALUES
    ('1', 'Order Placed'),
    ('2', 'Order Paid'),
    ('3', 'Accepted'),
    ('4', 'Picked by Courier'),
    ('5', 'In Transit'),
    ('6', 'Delivered'),
    ('7', 'Rated'),
    ('8', 'Rejected'),
    ('9', 'Canceled')
;

request_buy_id	invoice	traces_id	statuses_nama	RowNum
3	20220405/01104298	42	Delivered	1