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