What number does this SQL query actually run? Go!

Опубликовано 2 февраля 2026, 14:00

Here’s a SQL puzzle that looks almost too straightforward.We’re counting users and excluding banned and inactive ones using NOT IN. Assume the table has 100 active users, plus some banned and inactive rows. Many developers would expect this to return 100. It doesn’t. What number does this query actually return, and why?

Subscribe to Google for Developers → goo.gle/developers

Speakers: Jasmyne Roberts