Deals Of The Week - 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 supplier_id and a company_name. 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: 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.