Learn Practice Projects Free datasets Resources Toolkit Pricing

Loading this exercise…

Loading…

Hands-on analytics engineering training with browser-based practice, guided projects, and a human-reviewed capstone.

support@analyticsengineering.com

Learn

The course
Roadmap
Practice
Projects
Free datasets
Resources
Templates
Open-source toolkit
Jobs
Job market data
Guides
Glossary
Compare tools
Starting-point quiz

Topics

Analytics Engineering
SQL
dbt
Data Modeling
BigQuery
Snowflake
Looker
Python
Career
Interview Prep

Company

About
1-on-1 coaching
Pricing
Log in
Start free

Terms Privacy Built by Routeless

Loading this exercise…

Complex Conditions With AND/OR · SQL: Advanced Filtering…

Home / Practice / SQL: Advanced Filtering and Pattern Matching

Complex Conditions With AND/OR

#6 · 6 of 10

SQL: Advanced Filtering and Pattern Matching

10 exercises

01Using IS NULLFree
02Check For Non-NULL ValuesFree
03Using BETWEEN For Date RangesFree
04Using IN For Multiple MatchesLocked
05Advanced Pattern Matching With LIKELocked
06Complex Conditions With AND/ORLocked
07Matching Items Starting With A VowelLocked
08Combining NOT IN With ConditionsLocked
09Using A Negative PatternLocked
10Combining BETWEEN And INLocked

Paid plan required

Unlock the full library.

This exercise is part of the full library. The Practice Pass unlocks hints, explanations, instant answer reveal, and all 1,604 graded exercises — one payment, lifetime access. (The full course adds the capstone and GPT tutor.)

See all plans →Log in

All exercises in SQL: Advanced Filtering and Pattern Matching10

SQL: Advanced Filtering and Pattern Matching

10 exercises

01Using IS NULLFree
02Check For Non-NULL ValuesFree
03Using BETWEEN For Date RangesFree
04Using IN For Multiple MatchesLocked
05Advanced Pattern Matching With LIKELocked
06Complex Conditions With AND/ORLocked
07Matching Items Starting With A VowelLocked
08Combining NOT IN With ConditionsLocked
09Using A Negative PatternLocked
10Combining BETWEEN And INLocked