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_DTL AS O2
INNER JOIN ITEM AS I
ON O2.ITEM_CODE = I.ITEM_CODE
WHERE O2.ORDER_NO IN (
    SELECT
      O1.ORDER_NO
    FROM
      ORDERS AS O1
    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