Databases Querying Relational Databases Subqueries Subqueries

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?

1 Answer

54,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)