Dog Bath Anti-Join | Easy SQL Problem

In this video we write a SQL query involving an anti-join, a very common and useful querying technique.

Video chapters
00:00 - Problem description and set-up
01:55 - Anti-joins
03:09 - LEFT JOIN with NULL check
04:58 - NOT IN clause
05:56 - NOT EXISTS clause
07:34 - Comparing solutions
10:22 - Outro

If you would like to follow along at home and have a crack at solving this problem:
Local environment set-up instructions are in the Write a SQL Query GitHub repo README: https://github.com/cedwards036/write-...
The problem set-up code for today's episode can be found here: https://github.com/cedwards036/write-...

Thumbnail art and channel logo: FriezerBurnt https://www.friezerburnt.com/

Recording set up:
Database: PostgreSQL run locally in a docker container
SQL client: DBeaver https://dbeaver.io/
Microphone: Samson Q2U https://samsontech.com/products/micro...
Recording software: OBS https://obsproject.com/

Thank you for watching! Leave a comment below if you can think of any alternate solutions to today's problem, have suggestions for future videos, or just like to chat. Happy querying!