Answer the question
In order to leave comments, you need to log in
What is the precedence of operations in WHERE?
Print the title, author, price, and quantity of all books whose price is less than 500 or greater than 600, and the cost of all copies of these books is greater than or equal to 5000.
select title,
author,
price,
amount,
from book
where price > 600 or price < 500 and price * amount >= 5000
select title,
author,
price,
amount,
from book
where (price > 600 or price < 500) and price * amount >= 5000
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question