SQL · Reading data

and / or / not

Combines predicates. Use parentheses because AND binds tighter than OR.

sqlRunnable example sql course

Syntax

where a and (b or c)

Example

Open in the lab

WITH lessons(title, minutes) AS (VALUES ('HTML', 12), ('CSS', 18))
SELECT title FROM lessons WHERE minutes >= 10 AND NOT title = 'HTML';

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.