Please sorry my friends, I'm coming back

Question

You are managing a delivery office and need to prioritize your orders.
Order is considered a high priority order if
- the purchase total exceeds $400
and
- the customer's age is greater than 40 or the distance from the office to the delivery point is under 10 miles.

You are given the following 'orders' table with details:

Answer 1

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

Answer 2

And what are your thoughts on how the query should look?

Answer 3

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

Answer 4

Notice that the problem description implies there should be parentheses around the OR expression.

(Age > 40 OR Distance < 10)

Even if Age<=40 it will still be high priority if Distance<10 miles.

Answer 5

Let me see