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

Creating Basic SQL Reports in SQL Server

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 CustomerID, which is a five-letter abbreviation of the full company name stored in the CompanyName column. There are also columns related to the contact person (ContactName and ContactTitle) 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!