From the course: MySQL Data Analysis

Unlock this course with a free trial

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

Challenge: GROUP BY

Challenge: GROUP BY - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

Challenge: GROUP BY

“

- [Instructor] All right, now you're ready for your assignment on Group By. For this assignment, your uncle Jimmy is looking for a quick overview of how long you're renting out your movies. He wants you to pull a count of titles sliced by rental duration. Your results should look like this with one column showing the rental duration, and then another column showing the number of films that have that rental duration. And for bonus points, use an alias to match the column names to what you see here. Just like all the assignments, I encourage you to try this out on your own first, struggle through it, and then come back and watch the solution video, good luck.

Contents