select
    ITEM_CODE,
    ITEM_NAME,
    UNIT_PRICE,
    DISCOUNT_RATE,
    round(unit_price*(100-discount_rate)/100,0) as DISCOUNT_PRICE
from tbl_item
order by item_code desc;