Help with Challenege 1 of 4

For others accessing this question, it relates to the Code Challenge here: https://teamtreehouse.com/library/querying-relational-databases/subqueries/subqueries

In a car database there is a Model table with columns, ModelID, MakeID and ModelName and a Car table with columns, CarID, ModelID, VIN, ModelYear and StickerPrice.

Use a subquery along with IN to list all the Model Names with a Sticker Price greater than $30000

Firstly, you just need to list the Model Names:

SELECT ModelName FROM Model

As it's a subquery as part of an IN statement, you don't need to join the two tables. You can connect the ModelID columns for both the Model and Car tables as follows:

SELECT ModelName FROM Model
WHERE ModelID IN (
  SELECT ModelID FROM Car
)

The WHERE clause contains the ModelID from the Model table and the subquery contains the ModelID from the Car table. Lastly you just need to filter the subquery by the StickerPrice:

SELECT ModelName FROM Model
WHERE ModelID IN (
  SELECT ModelID FROM Car
  WHERE StickerPrice > 30000
);

Thank you Other Joel =+)

I was over thinking this as well!!! And had not yet understood that they were ONLY wanting to see the ModelNames and not to also see the StickerPrice

SELECT ModelName FROM Model WHERE ModelID IN (SELECT ModelID FROM Car WHERE StickerPrice > 30000);

1. Selecting the model name from the model table.
2. specifying the model id from the car tables
3. specifying even further the model id that has a sticker price greater than 30,000

Thank you very much for the correct answer!I am grateful! And I´ve learnt something new as well. Many greetings from Bernt