From the course: Advanced MySQL Data Analysis

Unlock this course with a free trial

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

Assignment: Finding top entry pages

Assignment: Finding top entry pages - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Assignment: Finding top entry pages

“

- [Instructor] All right, it's time for your next assignment. This time on identifying top entry pages to the website. So Morgan's back again and she'd like you to pull a list of your top entry pages, meaning the top pages where a customer lands on your website for the first time. Sometimes we'll say landing page, sometimes we'll say entry page. This can be used interchangeably and this is the similar to what you'll find in the real world too. You'll want to pull results where created at is less than June 12th, 2012, and your results should look like this with the landing page in one column, and then the number of sessions hitting that landing page in the second column. This is sort of similar to your previous exercise where you were just pulling all pages, except this time you're going to have to limit your records just to the first session that someone saw when they hit your website. It's a little trickier, but I think you're going to be able to get it. Please try to do this on your…

Contents