0

Please who can help me to fixed this codes

SELECT * FROM Orders WHERE Price = 400 AND (Age > 40 OR Distance < 10) ORDER BY Price;

11th Sep 2021, 10:26 AM
Jamilu Abubakar Sadiq
Jamilu Abubakar Sadiq - avatar
5 Respostas
+ 3
Thanks I fixed it SELECT * FROM Orders WHERE (Age > 40 OR Distance < 10) AND Price > 400 ORDER BY Price;
11th Sep 2021, 11:38 AM
Jamilu Abubakar Sadiq
Jamilu Abubakar Sadiq - avatar
+ 1
Please fixed it for me
11th Sep 2021, 11:04 AM
Jamilu Abubakar Sadiq
Jamilu Abubakar Sadiq - avatar
+ 1
Okay SELECT * FROM Orders WHERE Price > 400 AND Age > 40 OR Distance < 10 ORDER BY Price; but it can't be fixed
11th Sep 2021, 11:12 AM
Jamilu Abubakar Sadiq
Jamilu Abubakar Sadiq - avatar
0
Can you please describe your problem a little bit better...?
11th Sep 2021, 10:57 AM
Rupali Haldiya
Rupali Haldiya - avatar
0
And Expected output is Adam 38, 2, 500 Lisa 44, 13, 750
11th Sep 2021, 10:59 AM
Jamilu Abubakar Sadiq
Jamilu Abubakar Sadiq - avatar