From the course: Advanced MySQL Data Analysis

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Solution: Finding top entry pages

Solution: Finding top entry pages - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Solution: Finding top entry pages

“

- [Instructor] Hi, everyone. This is the solution video for the assignment on identifying top entry pages. As a reminder, Morgan is coming to you on June 12th, 2012, and she wants you to pull a list of top entry pages to the website. She'd like you to rank them on entry volume so that she understands which ones are most important, and which pages are receiving the most entries by your customers. Let's jump into Workbench and walk through the solution. Before I actually talk about the code, I want to stress the importance of this particular assignment. While it may seem like a pretty simple example, the fact that it gets you using temporary tables is really, really important to your development as an analyst. We're going to be using temporary tables a lot more, we're going to be writing multi-step queries a lot more. So while we're still on this fairly simple example, I'd really like for you to make sure that you master this concept. And if you weren't able to get this on your own, I'd…

Contents