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
Providing detailed information and counting objects
Calculating metrics for multiple business objects
Understanding the difference between various count metrics
Summary
16. Question 2

Instruction

Great work! Let's try something a little harder...

Exercise

Show three kinds of information about product suppliers:

  1. AllSuppliers (the total number of suppliers)
  2. SuppliersRegionAssigned (the total number of suppliers who are assigned to a region)
  3. UniqueSupplierRegions (the number of unique regions suppliers are assigned to)

Stuck? Here's a hint!