Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
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.