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 doesn't display the subtotal as above $4,000:

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