Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Get to know the database
6. The Suppliers table


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.


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.