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;