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