Question

1. All ingredients purchased in November. Display the ingredient id, name, date ordered, quantity & unit (in one column), unit price, and total amount for each item. Order the result set by descending date ordered. Hint: total amount is quantity multiplied by unit price.

(ORA-00904: "MONTH": invalid identifier)

SELECT ingredient_id, ingredient_name, date_ordered, "Quantity & Unit" AS Quantity,
unit_price * quantity AS "Total Amount"
FROM ingredient
WHERE month('date_ordered') = 11
ORDER BY 'date_ordered' DESC;

Answer 1

/8 Try using following if you are using oracle database*/

SELECT ingredient_id, ingredient_name, date_ordered, "Quantity & Unit" AS Quantity,
unit_price * quantity AS "Total Amount"
FROM ingredient
WHERE extract(month from 'date_ordered') = 11
ORDER BY 'date_ordered' DESC;