0

You are managing a delivery office and need to prioritize your orders. Order is considered a high priority order if - the purcha

SELECT * FROM orders WHERE (age >= 40 OR distance < 10) AND price >= 400; it don't show expected result in code coach help me!

21st Feb 2022, 1:47 PM
Paritosh Thakur
Paritosh Thakur - avatar
3 Respostas
+ 4
Order by *something*;
21st Feb 2022, 1:54 PM
Simba
Simba - avatar
+ 1
SELECT * FROM orders WHERE (age > 40 OR distance < 10) AND price > 400 ORDER BY price;SELECT * FROM orders WHERE (age > 40 OR distance < 10) AND price > 400 ORDER BY price; now i have solved the challenge
21st Feb 2022, 2:44 PM
Paritosh Thakur
Paritosh Thakur - avatar
+ 1
SELECT * FROM orders WHERE (age > 40 OR distance < 10) AND price > 400 ORDER BY price;
21st Feb 2022, 2:45 PM
Paritosh Thakur
Paritosh Thakur - avatar