End of Summer - hours only!Up to 80% off on all courses and bundles.-Close
2. The orders table
Customer activity
Finding good customers


Before we dive into our new report types, let's take a look at the tables we'll query. First, there's the orders table. It keeps track of all orders placed in our e-store. Let's examine some of its rows.


Select all columns for all orders placed by the customer with the ID of 34. As you can see, there are over ten columns available. The two most important ones are customer_id and total_amount.

Stuck? Here's a hint!