Loading video...

Video Failed to Load

Go Home

Is your user analytics query telling the whole story? This SQL developer challenge reveals a common mistake in counting active users. Can you spot what's making the numbers look lower than they should be?

googledevs's profile picture

Google for Developers

2,658,721 subscribers

23,846 views • 1 year ago •via X (Twitter)

Science & TechnologyNews & PoliticsEducation
LIVE

Anya Rossi• Live Now

Private livecam show

2 Comments

Google for Developers's profile picture
Google for Developers1 year ago

Think about how your counting method might be affected by users with multiple activity dates. Also, consider whether your HAVING clause is using the same counting logic as your SELECT statement.

Ash's profile picture
Ash1 year ago

HAVING COUNT(*) > 100 will show only regions where active users are greater than 100.

Related Videos

Your user global app’s metrics might be muddled by a gotcha! Check out this SQL dev challenge about a common tracking issue that affects users worldwide. Tell us where we went wrong and how to fix it in the comments below.
0:25

Your user global app’s metrics might be muddled by a gotcha! Check out this SQL dev challenge about a common tracking issue that affects users worldwide. Tell us where we went wrong and how to fix it in the comments below.

Google for Developers

23,832 views • 1 year ago

Developers, can you spot the bug in this seemingly simple code? It's a common C mistake that leads to undefined behavior!
0:22

Developers, can you spot the bug in this seemingly simple code? It's a common C mistake that leads to undefined behavior!

Google for Developers

24,599 views • 5 months ago

5 Common Vegetables You Should Never Refrigerate - Are You Making This Mistake?
1:01

5 Common Vegetables You Should Never Refrigerate - Are You Making This Mistake?

Health | Wellness | Nutrition

29,236 views • 1 year ago

Common mistake to confuse me with an actual star. Tune in tonight for stars in the making! #AmericanIdol reveals your Top 24!
0:38

Common mistake to confuse me with an actual star. Tune in tonight for stars in the making! #AmericanIdol reveals your Top 24!

Ryan Seacrest

27,642 views • 1 year ago

This should be the #1 Story in the United States 😠 The numbers will irritate you, be warned 🫵
4:41

This should be the #1 Story in the United States 😠 The numbers will irritate you, be warned 🫵

G-PA

226,671 views • 11 months ago

this immigrant is telling you, native american, than you can move anywhere in the world and you will never be one of them, all while telling you that anyone in the world can move to your home and be considered equal to one of you it is long past time they all go back
0:22

this immigrant is telling you, native american, than you can move anywhere in the world and you will never be one of them, all while telling you that anyone in the world can move to your home and be considered equal to one of you it is long past time they all go back

🅱️ete oaks

34,025 views • 7 days ago

Kevin Hassett on the jobs numbers: "This is a lower number than seems like you would normally get."
0:44

Kevin Hassett on the jobs numbers: "This is a lower number than seems like you would normally get."

The Bulwark

20,961 views • 9 months ago

Quick demo of Zero’s new background queries. Zero’s sync is query-based. Rather than specifying what data you want using rules or some other separate system, you just use queries. Right inside the client app, you do a query using a full sql-style language. You get filters, subqueries , limits, etc. Zero syncs the data backing these queries to the client. It’s important to realize Zero isn’t really a cache. It’s a replica. It’s eagerly replicating a precise snapshot of a slice of your database - the slice covered by the queries you have open. So there is never stale data in Zero. When you close a query we delete the rows uniquely returned by that query because we can no longer keep them up to date. Of course that kind of sucks for the common case of doing a query, navigating, then pressing “back”. Ideally we want that back nav to be fast. To address this Zero 0.17 adds background queries. You can add a ttl to a query and it will keep running and syncing in the background. This is much different than normal caching because this data stays up to date. If you make the same query again, the results will be *instantly* available *and already up to date with server*. If you make a different query the data from the background query is used client-side to answer the new query instantly if possible. This all happens completely automatically. Just by adding the ttl flag.
1:01

Quick demo of Zero’s new background queries. Zero’s sync is query-based. Rather than specifying what data you want using rules or some other separate system, you just use queries. Right inside the client app, you do a query using a full sql-style language. You get filters, subqueries , limits, etc. Zero syncs the data backing these queries to the client. It’s important to realize Zero isn’t really a cache. It’s a replica. It’s eagerly replicating a precise snapshot of a slice of your database - the slice covered by the queries you have open. So there is never stale data in Zero. When you close a query we delete the rows uniquely returned by that query because we can no longer keep them up to date. Of course that kind of sucks for the common case of doing a query, navigating, then pressing “back”. Ideally we want that back nav to be fast. To address this Zero 0.17 adds background queries. You can add a ttl to a query and it will keep running and syncing in the background. This is much different than normal caching because this data stays up to date. If you make the same query again, the results will be *instantly* available *and already up to date with server*. If you make a different query the data from the background query is used client-side to answer the new query instantly if possible. This all happens completely automatically. Just by adding the ttl flag.

Aaron Boodman

18,808 views • 1 year ago

This is something the western mainstream media should be telling you. But they won't.......
1:29

This is something the western mainstream media should be telling you. But they won't.......

Richard

377,781 views • 2 years ago

DON’T BE THIS TYPE OF PLAYER Nothing worse than a player that won’t challenge themselves defensively. You might not be the best defender, but you can fight, scrap, get steals, and still impact the game on that side of the floor. Also, nothing worse than a player that stops playing when they make a mistake. YOUR TEAM BEEDS YOU TO MAKE THE NEXT PLAY!! Stop being selfish. Challenge yourself to never be this type of player.
0:29

DON’T BE THIS TYPE OF PLAYER Nothing worse than a player that won’t challenge themselves defensively. You might not be the best defender, but you can fight, scrap, get steals, and still impact the game on that side of the floor. Also, nothing worse than a player that stops playing when they make a mistake. YOUR TEAM BEEDS YOU TO MAKE THE NEXT PLAY!! Stop being selfish. Challenge yourself to never be this type of player.

Steve Dagostino

12,895 views • 1 year ago

"Modern Football in the NFL is Quarterback driven. You can look at the analytics... QB Success is a higher predictor of winning and losing than Turnover Ratio." - Ben Johnson
1:05

"Modern Football in the NFL is Quarterback driven. You can look at the analytics... QB Success is a higher predictor of winning and losing than Turnover Ratio." - Ben Johnson

Coach Dan Casey

1,102,157 views • 1 year ago

What's the truth, @SheehyforMT? Telling investigators one story and then telling others the bullet in your arm is from Afghanistan? This is just one more story that doesn't add up, Tim. Montana deserves better.
0:30

What's the truth, @SheehyforMT? Telling investigators one story and then telling others the bullet in your arm is from Afghanistan? This is just one more story that doesn't add up, Tim. Montana deserves better.

VoteVets

66,421 views • 2 years ago

This man reveals the biggest mistake you can do when raising a kid.
0:50

This man reveals the biggest mistake you can do when raising a kid.

The Driven Man

120,464 views • 3 months ago

Silence is telling the whole story. Just look at Dad's face! 😂😭
0:21

Silence is telling the whole story. Just look at Dad's face! 😂😭

Restoring Your Faith in Humanity

122,489 views • 1 month ago

🎉 Check out our amazing growth rates in Google Analytics! 📈 With over 3,000,000 players and more than 1,300,000 daily active users (DAU) 🔥 Incredible results. And this is just the beginning! #hamster_kombat
0:32

🎉 Check out our amazing growth rates in Google Analytics! 📈 With over 3,000,000 players and more than 1,300,000 daily active users (DAU) 🔥 Incredible results. And this is just the beginning! #hamster_kombat

Hamster Kombat

160,880 views • 2 years ago

Write this down: If you choose to be part of a team… showing up as less than your best is selfish. Your standard impacts everyone else. When you don’t bring your best, you lower the ceiling for the whole room. Lead accordingly.
0:47

Write this down: If you choose to be part of a team… showing up as less than your best is selfish. Your standard impacts everyone else. When you don’t bring your best, you lower the ceiling for the whole room. Lead accordingly.

Alan Stein, Jr.

17,854 views • 3 months ago

A basic mistake that can be made in understanding the followership of Cockroach Janta Party and this mistake should be avoided 🙏
1:37

A basic mistake that can be made in understanding the followership of Cockroach Janta Party and this mistake should be avoided 🙏

Shekhar Dutt

142,690 views • 23 days ago

Caught up with Mike McAllister on Syracuse men's basketball's transfer portal additions 🍊🏀 Should fans be concerned by the lack of P4 transfers? "Last year, the whole was less than the sum of the parts, and you're hoping this year the whole is greater than the sum of the parts." "They have more resources than last year..the market for transfers is also up. If you look at the roster as a whole, I think you can see the way it's constructed. They want positional size, length, and defensive intensity."
1:24

Caught up with Mike McAllister on Syracuse men's basketball's transfer portal additions 🍊🏀 Should fans be concerned by the lack of P4 transfers? "Last year, the whole was less than the sum of the parts, and you're hoping this year the whole is greater than the sum of the parts." "They have more resources than last year..the market for transfers is also up. If you look at the roster as a whole, I think you can see the way it's constructed. They want positional size, length, and defensive intensity."

Ashley Wenskoski

10,389 views • 1 month ago

XION has over 800k monthly active users. @EarnOS_io, built on XION, has 4M users. Dave, our Premier Mobile Developer Kit brings in 18M iOS and Android developers. This is what happens when you make blockchain useful, not just usable. Making XION the Unicorn of Unicorns🧵↓
1:44

XION has over 800k monthly active users. @EarnOS_io, built on XION, has 4M users. Dave, our Premier Mobile Developer Kit brings in 18M iOS and Android developers. This is what happens when you make blockchain useful, not just usable. Making XION the Unicorn of Unicorns🧵↓

XION

38,355 views • 11 months ago

This SQL query looks like it should fail immediately. Instead, it runs and quietly returns the wrong result. Why doesn’t the database complain?
0:40

This SQL query looks like it should fail immediately. Instead, it runs and quietly returns the wrong result. Why doesn’t the database complain?

Google for Developers

11,376 views • 3 months ago