SQL Editor

SQL Subquery Example

Task:

List all suppliers and the number of products they offer.
Click here for details on Subquery.
 
 29 Records
CompanyName ProductCount
Exotic Liquids 3
New Orleans Cajun Delights 4
Grandma Kelly's Homestead 3
Tokyo Traders 3
Cooperativa de Quesos 'Las Cabras' 2
Mayumi's 3
Pavlova, Ltd. 5
Specialty Biscuits, Ltd. 4
PB Knäckebröd AB 2
Refrescos Americanas LTDA 1
Heli Süßwaren GmbH & Co. KG 3
Plutzer Lebensmittelgroßmärkte AG 5
Nord-Ost-Fisch Handelsgesellschaft mbH 1
Formaggi Fortini s.r.l. 3
Norske Meierier 3
Bigfoot Breweries 3
Svensk Sjöföda AB 3
Aux joyeux ecclésiastiques 2
New England Seafood Cannery 2
Leka Trading 3
Lyngbysild 2
Zaanse Snoepfabriek 3
Karkki Oy 3
G'day, Mate 3
Ma Maison 2
Pasta Buttini s.r.l. 2
Escargots Nouveaux 1
Gai pâturage 2
Forêts d'érables 2
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.