1Z0-051Preview

Examine the structure and data in the PRICE_LIST table:

Name Null Type -

PROD_ID NOT NULL NUMBER(3)
PROD_PRICE VARCHAR2(10)

PROD_ID PROD_PRICE -

100 $234.55
101 $6,509.75
102 $1,234
You plan to give a discount of 25% on the product price and need to display the discount amount in the same format as the PROD_PRICE.
Which SQL statement would give the required result?