Write For Us

What number does this SQL query actually run? Go!

E-Commerce Solutions SEO Solutions Marketing Solutions
10 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

ava
Published
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
Category
Project
Tags
Google, developers, pr_pr: Google for Developers;
Sign in or sign up to post comments.
Be the first to comment

Up Next