Users Who Never Logged In
medium~30 min
You need a list of users who have never logged in — the login_events table has zero rows for these users. Explain how to correctly write this query (the anti-join pattern), and a common mistake to avoid.
Solution
This one has no written solution — the answer is your own story or your own submission.