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
Method One
Method Two
Method Three
Summary
12. Question 2

Instruction

Good job! Let's move on to the next question!

Exercise

Let's count how many customers we have in each language group, which is based on the language used in their country of residence. Show three columns:

  1. EnglishCount – the number of customers from UK, Canada, USA, and Ireland.
  2. GermanCount – the number of customers from Germany, Switzerland, and Austria.
  3. OtherCount – the number of customers from other countries.

Stuck? Here's a hint!