attempting to complete an assignment for a class learning SQL, we have to run commands via LIVE SQL
The question is as follows:
List all information for each order item. Include an item total, which can be calculated by multiplying the Quantity and Paideach columns. Use a column alias for the calculated value to show the heading “Item Total” in the output.
So my first thoughts would be the following statement
SELECT *, Quantity*Paideach AS “Item Total”
FROM orderitems;
and i get the following error message
ORA-00923: FROM keyword not found where expected
independently the * and Quantity*Paideach AS “Item Total” work perfectly fine, i only get the error message when putting them together
any thoughts?