Combining AND & OR

Question

Error Message:

ERROR: syntax error at or near "order"
LINE 1: order by price
^

Code:

select *
from orders
where price >400 and (distance <10 or age >40);
order by price;

I have tried to look through the previous lessons for answers and I do excactly as they did for when order by was shown in lesson. Now I am so confused at what is even wrong

Answer 1

Semicolon before oder statement should not come

The semicolon should be at the end of the statement only

select * from orders where price > 400 and (distance < 10 or age > 40) order by price;

Answer 2

Marc8539 it often happens for a programmer 🙂

Answer 3

Oh my that was honestly a dumb mistake, how was I confused for so long about that