Snippet

Structuring Complex Logical Filters with Parentheses

Explicitly grouping conditions with parentheses ensures correct logical operator precedence (AND vs. OR), avoiding unexpected filtering bugs.

snippet.sql

sql

SELECT product_name, price
FROM products
WHERE (category = 'Electronics' OR category = 'Books')
  AND price < 50;

Breakdown

SELECT product_name, price

Specifies the columns to retrieve from the matching records.

FROM products

Names the target table containing product information.

WHERE (category = 'Electronics' OR category = 'Books')

Groups the category criteria so that either category matches first.

AND price < 50;

Applies the price limit condition to whichever category matched.