select 
    od.ITEM_CODE as CODE
    , ITEM_NAME as NAME
    , sum(UNITPRICE*ORDER_QTY) as TOTAL_AMT
from 
    ORDERS o
    left outer join
        ORDERS_DTL od
        on o.ORDER_NO = od.ORDER_NO
    left outer join
        ITEM i
        on od.ITEM_CODE = i.ITEM_CODE
where
    ORDER_DATE between '2023-05-14' and '2023-05-20'
group by
    od.ITEM_CODE
    , ITEM_NAME
order by
    TOTAL_AMT desc
    , od.ITEM_CODE desc
limit 5
;