SELECT
    ORDED.ITEM_CODE  AS CODE
    , IT.ITEM_NAME  AS NAME
    , sum(ORDED.UNITPRICE * ORDED.ORDER_QTY) AS TOTAL_AMT 
FROM
    ORDERS AS ORDE
    INNER JOIN ORDERS_DTL AS ORDED
    ON ORDE.ORDER_NO = ORDED.ORDER_NO 
    INNER JOIN ITEM AS IT
    ON ORDED.ITEM_CODE = IT.ITEM_CODE
WHERE
    ORDE.ORDER_DATE BETWEEN date('2023-05-14') AND date('2023-05-20')
group by IT.ITEM_CODE
ORDER BY
    sum(ORDED.UNITPRICE * ORDED.ORDER_QTY)  DESC
    , ORDED.ITEM_CODE DESC
LIMIT 5;