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