Databases Querying Relational Databases Subqueries Subqueries

2 Answers

Yassin Chiguer
Yassin Chiguer
5,096 Points

Try this: select modelname from model where modelid in (select modelid from car where stickerprice > 30000)

ivana kantnerova
ivana kantnerova
10,479 Points

Select ModelName from Model where ModelID IN ( Select ModelID from Car where StickerPrice > 30000)

Impala Colorado Cherokee Grand Cherokee Accord Camry Sienna