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.

Assignment: Finding top website pages

Assignment: Finding top website pages - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Assignment: Finding top website pages

- [Instructor] All right, you're ready for your assignment on identifying top website pages. For this assignment, you'll be working with a new website manager, Morgan Rockwell. Website managers love their analysts because they help them figure out what's going on on the site. So this is a great opportunity for you to make an impact with Morgan and help her figure out how you can make the website better. Morgan's brand new, so she needs help with some day one stuff. The first thing she needs from you is to identify what your most viewed website pages are. She wants to see something like this, where you show her the pageview_url and the count of sessions. And like all the assignments, there'll be a date restriction here based on when the request came in. So you'll want to use traffic where the created at was before June 9th, 2012. Go ahead and give this a shot. Try to do it on your own, struggle through if you need to, and then come back and watch the solution video, and we'll…

Contents