Databases Querying Relational Databases Subqueries Subqueries

2 Answers

Yassin Chiguer
Yassin Chiguer
4,941 Points

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

ivana kantnerova
ivana kantnerova
10,388 Points

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

Impala Colorado Cherokee Grand Cherokee Accord Camry Sienna