SELECT S.CODE, S.NAME, SUM(S.TOTAL) AS TOTAL_AMT FROM
(
SELECT OD.ITEM_CODE AS CODE, I.ITEM_NAME AS NAME,OD.UNITPRICE * OD.ORDER_QTY AS TOTAL  FROM
(SELECT ORDER_NO FROM ORDERS
WHERE ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20') O
INNER JOIN 
 ORDERS_DTL OD 
ON O.ORDER_NO = OD.ORDER_NO
INNER JOIN ITEM I ON OD.ITEM_CODE = I.ITEM_CODE
) S
GROUP BY S.CODE, S.NAME
ORDER BY TOTAL_AMT DESC, CODE ASC
LIMIT 5