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;