SELECT
    ITEM_CODE AS CODE
    ,ITEM_NAME AS NAME
    ,SUM(UNITPRICE * ORDER_QTY) AS TOTAL_AMT
FROM (
SELECT * 
FROM ORDERS_DTL
LEFT JOIN ITEM
ON ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE
LEFT JOIN ORDERS
ON  ORDERS_DTL.ORDER_NO = ORDERS.ORDER_NO
) T1
WHERE ORDER_DATE <= '2023-05-20' and ORDER_DATE >= '2023-05-14'
GROUP BY ITEM_CODE,ITEM_NAME
ORDER BY SUM(UNITPRICE * ORDER_QTY) Desc,ITEM_CODE Desc
LIMIT 5;