select
    ITEM_CODE
    ,ITEM_NAME
    ,UNIT_PRICE
    ,DISCOUNT_RATE
    ,round(
        UNIT_PRICE*(1-DISCOUNT_RATE/100) 
        ) as DISCOUNT_PRICE
from
    TBL_ITEM
order by
    ITEM_CODE desc;