Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
2. Important columns in the customers table
Conversion rates
Time to first order
Conversion charts


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


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'