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
6. The Suppliers table
Summary

Instruction

Good job! Next, we have the Suppliers table, which is similar to the Customers table. Each supplier has a unique SupplierID and a CompanyName. There are also columns containing each supplier's contact information.

Exercise

We'd like to see information about all the suppliers who provide the store four or more different products. Show the following columns: SupplierID, CompanyName, and ProductsCount (the number of products supplied).

Stuck? Here's a hint!

Join the Products and Suppliers tables. Use a GROUP BY clause. To return only those suppliers with four or more products, use a HAVING clause with the COUNT function.