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