Can't get past Task 2 of 4 - Querying Relational Databases
In a car database there is a Sale table with columns, SaleID, CarID, CustomerID, LocationID, SalesRepID, SaleAmount and SaleDate and a Car table with columns, CarID, ModelID, VIN, ModelYear and StickerPrice. Use a subquery along with IN to list all sales of cars with Sticker Price greater than $30000. Include all columns.
It says that I am "missing the IN keyword" even though I have it in there.... wondering if this is a glitch in the system or if my code is incorrect?
KRIS NIKOLAISEN54,287 Points
This is very similar to the first task. The following passed task 2:
SELECT * FROM Sale WHERE CarID IN (SELECT CarID FROM Car WHERE StickerPrice > 30000)