my ansewr worked select c.model,c.brand,c.mileage,c.prod_year from car c where c.prod_year > (select prod_year from car where id=2) and c.original_price > (select original_price from car where id=1) ------------ their answer SELECT c1.model, c1.brand, c1.mileage, c1.prod_year FROM car c1 JOIN car c2 ON c1.prod_year > c2.prod_year JOIN car c3 ON c1.original_price > c3.original_price WHERE c2.id = 2 AND c3.id = 1
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter