Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Customer Behavior Analysis in SQL

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!