SQL Editor

SQL Group By Example

Task:

List the number of products for each supplier, sorted high to low.
Click here for details on Group By.
 
 29 Records
CompanyName Products
Pavlova, Ltd. 5
Plutzer Lebensmittelgroßmärkte AG 5
Specialty Biscuits, Ltd. 4
New Orleans Cajun Delights 4
Norske Meierier 3
Formaggi Fortini s.r.l. 3
Mayumi's 3
Bigfoot Breweries 3
Exotic Liquids 3
G'day, Mate 3
Grandma Kelly's Homestead 3
Heli Süßwaren GmbH & Co. KG 3
Karkki Oy 3
Leka Trading 3
Svensk Sjöföda AB 3
Tokyo Traders 3
Zaanse Snoepfabriek 3
PB Knäckebröd AB 2
Aux joyeux ecclésiastiques 2
Lyngbysild 2
Ma Maison 2
Forêts d'érables 2
Cooperativa de Quesos 'Las Cabras' 2
New England Seafood Cannery 2
Gai pâturage 2
Pasta Buttini s.r.l. 2
Nord-Ost-Fisch Handelsgesellschaft mbH 1
Escargots Nouveaux 1
Refrescos Americanas LTDA 1
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.