Question

Create the report that is shown below. This a query to produce the summary of the value of products currently in inventory, that have a value of more than $4,000, as shown below. Note that the value of each product is produced by the multiplication of the units currently in inventory and the unit price. We are only interested in the attributes shown and in the order shown. We want the subtotal displayed as currency

What I have, but it gives me an error in line 3 that says "missing expression":

select prod_descript, prod_qoh, prod_price, prod_qoh * prod_price AS subtotal
from lgproduct order by prod_descript
where subtotal > 4000;

Answer 1

ANSWER

Select prod_descript, prod_qoh, prod_price, prod_qoh * prod_price AS "subtotal" from lgproduct where subtotal > 4000 order by prod_descript;

Above querry is excuted correct.

Note:- Theb subtotal must be a column name.

Mistake :- order by clause are putting after the where clause.

Hope it is helpfull to you.