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;