MySQL 5.7

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

create table delivery (item_code int, `date` date, quantity int)
insert into delivery values
(110192, '2019-05-05', 30),
(110192, '2019-01-01', 10),
(110192, '2019-10-10', 25),
(110192, '2019-08-08', 19)

Records: 4  Duplicates: 0  Warnings: 0


SELECT m.item_code, 
       m.min_date AS "First_delivery_date",  d1.quantity AS "First_quantity",
       m.max_date AS "Latest_delivery_date", d2.quantity AS "Latest_quantity"
FROM (SELECT item_code, MAX(date) AS max_date, MIN(date) AS min_date
      FROM delivery
      GROUP BY item_code) m
JOIN delivery d1 ON d1.item_code = m.item_code AND d1.date = m.min_date
JOIN delivery d2 ON d2.item_code = m.item_code AND d2.date = m.max_date


item_code
First_delivery_date
First_quantity
Latest_delivery_date
Latest_quantity


110192
2019-01-01
10
2019-10-10
25