- ) Write SQL code to list all vendors and the number of products they supply.

Given the structure and contents of the SaleCo database shown in Figure below, use SQL commands to answer problems: INVOICE PK INV_NUMBER INT(5) FK CUS_CODE INT(5) INV_DATE DATETIME CUSTOMER PK CUS_CODE INT(5) CUS_LNAME VARCHAR(50) CUS_FNAME VARCHAR(50) CUS_INITIAL CHAR(1) CUS_AREACODE CHAR(3) CUS_PHONE CHAR(8) CUS_BALANCE DECIMAL(13.2) LINE PK FK INV_NUMBER INT(5) PK LINE_NUMBER INT(2) FK P_CODE INT(5) LINE_UNITS INT(4) LINE_PRICE DECIMAL(13,2) VENDOR PK V_CODE INT(5) V_NAME VARCHAR(50) V_CONTACT VARCHAR(50) V_AREACODE VARCHAR(50) V_PHONE VARCHAR(50) V_STATE VARCHAR(50) V_ORDER VARCHAR(50) PRODUCT PK P_CODE INT(5) P_DESCRIPT VARCHAR(50) P_INDATE DATETIME P_Q INT(4) P_MIN P_PRICE DECIMAL(13.2) P_DISCOUNT DECIMAL(13,2) FK V_CODE INT(5) INT(4) SaleCo Database