课程: SQL Hands-On Practice: Solve Business Problems

免费学习该课程！

今天就开通帐号，24,700 门业界名师课程任您挑！

Solution: Explore variable distributions with CTEs

Solution: Explore variable distributions with CTEs - SQL教程

课程: SQL Hands-On Practice: Solve Business Problems

开始一个月试用 购买团队方案

Solution: Explore variable distributions with CTEs

“

- [Instructor] Welcome back. This problem is one of my favorites because it involves some data wrangling to reshape the data in the way that we want it. Plus finding the distribution of a variable is a super common live coding interview question for all data roles, so definitely make sure you understand this concept. Let's explore the frontend event definitions table by running select star from frontend event definitions. And now let's run it. Notice that it says incorrect output. That's okay because we're not done writing our query yet. We still have some work to do, but you can see how event ID number five is clicked link inside email. That's the event we're going to want to track. All right, now let's erase this query and write the real query for this problem. To count the number of events per user for event ID five, let's start with select star from. We're going to pull from the frontend event log table and we're…

内容