What number does this SQL query actually run? Go!

Author: Google for Developers - Bewertung: 8x - Views:123

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 → https://goo.gle/developers



Speakers: Jasmyne Roberts