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