select
    ORDERS_DTL.ITEM_CODE as 'CODE',
    ITEM.ITEM_NAME as 'NAME',
    UNITPRICE * sum(ORDER_QTY) as 'TOTAL_AMT'
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
where
    ORDER_DATE >= '2023-05-14' and ORDER_DATE <= '2023-05-20'
group by ORDERS_DTL.ITEM_CODE
order by TOTAL_AMT desc, ORDERS_DTL.ITEM_CODE desc
limit 5;