Hi,

I am trying to solve the following and despite my results I still receive following errors on this last question. Could you please show the correct method for future reference?

Also, our convention formats as I have shown below where we DO NOT use SELECT example1, example2.. but SELECT Product.ProductID.

What ProductIDs were sold in February 2015? Show each productID only once Customer CustomerID FirstName LastName StreetAddress City State PostalCode Country Phone Sale SalelD SaleDate CustomerID ProductID ItemSize Quantity SalePrice Product ProductID ProductName ManufacturerlD Category Color Price Description Manufacturer ManufacturerlD ManufacturerName Address City State PostalCode Phone 1 SELECT DISTINCT Product.ProductID 2 FROM Product 3 WHERE EXTRACT (YEAR FROM "Sale.SaleDate")-2015 AND 4 EXTRACT (MONTH FROM "Sale . SaleDate") 21 Open in Advanced Editor Save Answer Test Query Record Count: O SELECT DISTINCT Product.ProductID FROM Product WHERE EXTRACT (YEAR FROM Sale.SaleDate) 2015 Error ERROR [42S22] [Oracle)[ODBC][Ora]ORA-00904: "Sale.SaleDate: invalid identifier