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