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