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