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