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;