Cellwise · SQL track

Patterns, lists and missing values

Flexible filters, and how to find what’s missing.

LIKE matches patterns, where % means any characters. IN checks against a list, and BETWEEN checks a range, including both ends.

NULL means a value is missing. You can’t use = with it, so SQL has IS NULL instead.

What you’ll do

• Match a pattern
• Check against a list
• Find what’s missing