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