Welcome to the Treehouse Community
Looking to learn something new?
Claire Brehm9,098 Points
Task 1 challenge help
The question: 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
My code: SELECT modelid FROM model WHERE modelid IN (SELECT stickerprice FROM car WHERE stickerprice > 30000)
modelid IN is trying to match modelid's your subquery should be retrieving modelid's.