From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Challenge: Total number of orders by customer

From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Challenge: Total number of orders by customer

“

(upbeat music) - [Instructor] Here's our challenge. We want to build a totals query that gives us a number of total orders placed by customer. We also want it to be sorted with the highest number of orders first. The query needs to display the customer ID, the customer's name, as well as the total number of orders they place. But it also needs to show all the customers, even if they've not made an order. This challenge could take you anywhere from five to 10 minutes to complete, and it will leverage the skills you've learned in this chapter.

Contents