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