Learn SQLite in Neovim: Multi-Condition Filters with AND, OR, NOT | Episode 6

One WHERE condition is not always enough. In this episode, you learn to combine conditions with AND, OR, NOT, and parentheses for powerful multi-condition filters. We continue with our music library and write queries that filter by multiple criteria at once — recent AND short songs, Queen OR Eagles, NOT after 2000, and grouped conditions with parentheses. Student code: https://github.com/GoCelesteAI/learn-sqlite-in-neovim/tree/main/episode06 Every keystroke is shown on screen with 3-second pauses so you can follow along at your own pace. What You'll Learn: - AND — both conditions must be true (narrows results) - OR — either condition can be true (widens results) - NOT — flip a condition (returns non-matching rows) - Parentheses to control evaluation order - Combining AND + OR safely with grouping - Running SQL files with :!sqlite3 :memory Timestamps: 0:00 - Introduction 0:12 - Preview: What We Cover 0:44 - Creating and_or_not.sql 1:50 - CREATE TABLE songs (same music library) 3:07 - INSERT — eight songs 5:05 - SELECT * — all eight songs 5:40 - WHERE AND — recent AND short songs 6:16 - WHERE OR — Queen OR Eagles 6:53 - WHERE NOT — NOT after 2000 7:30 - Parentheses — (OR) AND grouping 8:13 - NOT with parentheses — outside a range 8:52 - Recap: 3 Key Takeaways 9:28 - End Screen Key Takeaways: 1. AND requires both conditions true — it narrows results 2. OR requires either condition true — it widens results 3. Use parentheses to control the order when mixing AND and OR This is Episode 6 of the Learn SQLite in Neovim series — 32 episodes from beginner to advanced. Taught by CelesteAI. Like & subscribe for more tutorials! #sqlite #sql #neovim #programming #tutorial #beginners #learnsql #database #and #or #not #sqlitetutorial #coding Tags sqlite, sqlite tutorial, learn sqlite, sql tutorial, sql for beginners, neovim sqlite, and or not sql, combining conditions, where clause, parentheses sql, neovim tutorial, learn sql in neovim, sql basics, sqlite episode 6, programming tutorial, coding tutorial, beginner programming, sqlite 2026, neovim 2026, screenkey, code along, database tutorial