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;