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.