3 lines
154 B
MySQL
3 lines
154 B
MySQL
|
select P_CODE as `Product Code`, P_DESCRIPT as `Product Description`, (P_PRICE * (1 - P_DISCOUNT)) as `Discounted Price`
|
||
|
from PRODUCT
|
||
|
where P_PRICE > 100;
|