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. Important columns in the customers table
Conversion rates
Time to first order
Conversion charts
Summary

Instruction

First, let's take another look at the customers table. It contains some important columns that we didn't use in the previous part.

Exercise

For all customers from London, select the following columns:

  • customer_id
  • first_order_id
  • first_order_date
  • last_order_id
  • last_order_date

These column names should be self-explanatory.

Stuck? Here's a hint!

Use the following WHERE clause:

WHERE city = 'London'