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: The HAVING clause

Challenge: The HAVING clause - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

Challenge: The HAVING clause

“

- [Instructor] All right, it's time to test out your skills on the having assignment. For this assignment, your business partner, Uncle Jimmy, is trying to get in touch with customers who haven't rented very much from you guys. He's wondering if he could maybe get some feedback from them so that he could figure out what you could do better. He wants you to pull a list of customer_ids which have less than 15 rentals all-time. Your result grid should look like this with customer_id on the left as your dimension, and total rentals as your metric, and you want to make sure that you only see customers with fewer than 15 rentals. I'll give my usual advice here. Please try this out on your own. Try to get to the solution, struggle through it. If you really get stuck, use the solution video, but ideally, you're struggling through this on your own, which will really help you learn the material. All right, good luck.

Contents