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