What number does this SQL query actually run? Go!

Estimated read time 1 min read

Post Contenthttps://www.youtube.com/shorts/KW6bXeDJEUE

​ 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   Read More Google for Developers 

You May Also Like

More From Author