Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
2. The orders table
Customer activity
Finding good customers
Summary

Instruction

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.

Exercise

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!