select
    ITEM.ITEM_CODE as 'CODE',
    ITEM.ITEM_NAME as 'NAME',
    UNITPRICE * 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 ITEM.ITEM_CODE
order by TOTAL_AMT desc, ITEM.ITEM_CODE desc
limit 5