Question

Find products that satisfy BOTH conditions below:______

Answer 1

Answer:

Explanation:

--> First constraint should be satisfied.

UnitPrice>=22.

--> In Second and third either of one should be satisfied.

CategoryID in (4,7,8) OR (CategoryID in (1,3) AND UnitsInStock >= 40)

--> So, Final statement is :

SELECT ProductID, UnitPrice, CategoryID, UnitsInStock FROM Products

WHERE UnitPrice>=22 AND (CategoryID in (4,7,8) OR (CategoryID in (1,3) AND UnitsInStock >= 40))