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