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