select  ITEM.ITEM_CODE as CODE,
        ITEM.ITEM_NAME as NAME,
        total(ORDERS_DTL.UNITPRICE * ORDERS_DTL.ORDER_QTY) as TOTAL_AMT
from    ORDERS
inner join ORDERS_DTL on ORDERS.ORDER_NO = ORDERS.ORDER_NO
inner join ITEM on ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE
where ORDERS.ORDER_DATE > '2023-05-13' and ORDERS.ORDER_DATE < '2023-05-21'
group by    CODE,
            NAME
order by    TOTAL_AMT desc,
            CODE desc
limit 5