SELECT
    *
    , ROUND(UNIT_PRICE*((100-DISCOUNT_RATE)/100), 0) AS DISCOUNT_PRICE
FROM
    TBL_ITEM
ORDER BY
    ITEM_CODE DESC;