From the course: MySQL Data Analysis

Unlock this course with a free trial

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

Challenge: Aggregate functions

Challenge: Aggregate functions - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

Challenge: Aggregate functions

“

- [Narrator] All right, we're ready for your assignment on using aggregate functions with group by. For this assignment, your business partner, Uncle Jimmy, is trying to figure out if you guys charge more for a rental when the replacement cost is higher. He wants you to pull a count of films with the average min and max rental rate and group that by replacement cost. Here's a preview of what your results should look like. You should have one column for replacement cost. That's going to be your dimension, and then you'll have these other four columns as metrics that go along with that dimension. As a bonus, use aliases to match these column names. This will make your code and your output more human readable per usual. I'm going to encourage you to work through this on your own, struggle through it, try to get to the answer, and then come back and watch the solution video. Good luck.

Contents