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 supplier_id and a company_name. 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: supplier_id, company_name, and products_count (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.