End of Summer - hours only!Up to 80% off on all courses and bundles.-Close
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'