What number does this SQL query actually run? Go!
6 260
19.5
Google Developers2.61M
Next
40 days β 13 9990:08Popular
20 days β 5 6370:41
24 days β 3 2040:41Published on 2 Feb 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
Subscribe to Google for Developers → goo.gle/developers
Speakers: Jasmyne Roberts
Fresh videos
4 days β 1630:27
6 days β 1 731 17810:42
6 days β 1 0734:35
6 days β 5 67421:46
10 days β 11 1410:41
10 days β 81 2190:25Random videos
13 days β 8 3850:41
10.11.24 β 1 296 4676:40
16.08.24 β 23 9701:04
01.11.23 β 1 1630:19
09.03.22 β 130 49811:56
10.08.10 β 7 0953:21
23 hours β 2 1820:06
2 days β 00:15
3 days β 16 8980:33
4 days β 42 0731:09
8 days β 946 4018:22
10 days β 11 6442:58
10 days β 7 184 0578:48