Write a query to display the vendor ID, vendor name, brand name, and number of products of each brand supplied by each vendor. Sort the output by vendor name and then by brandname.

Transcribed Image Text:

VEND D BRAND NAME İNUMPRODUCTS 27 VEND NAME 8 Baltimore Paints Consolidated 8 Baltimore Paints Consolidated 8 Baltimore Paints Consolidated 8 Baltimore Paints Consolidated 8 Baltimore Paints Consolidated 8 Baltimore Paints Consolidated 13 Boykin Chemical Workshop 13 Boykin Chemical Workshop 13 Boykin Chemical Workshop 13 Boykin Chemical Workshop 13 Boykin Chemical Workshop 13 Boykin Chemical Workshop BINDER PRIME FORESTERS BEST HOME COMFORT LE MODE LONG HAUL VALU-MATTE BUSTERS LE MODE LONG HAUL OLDE TYME QUALITY STUTTENFURST VALU-MATTE 36