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