On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Get to know the database
4. The customers table
Summary

Instruction

Perfect! Let's move on to the customers table.

Each customer has a unique customer_id, which is a five-letter abbreviation of the full company name stored in the company_name column. There are also columns related to the contact person (contact_name and contact_title) and some related to the customer's address and fax number.

Exercise

Select each customer's ID, company name, contact name, contact title, city, and country. Order the results by the name of the country.

Stuck? Here's a hint!