SQL

1. List the productCode, productName, and count of orders for the product with the mostorders where the productVendor is Welly Diecast Productions. Make sure to title the column heading for the count of orders as OrderCount.

Payments Check Number VARCHAR(50) payment Date DATETIME amount DOUBLE customer Number INT(11) Indexes Offices officeCode VARCHAR(10) ity VARCHAR(50) prone VARCHAR(50) addressLine1 VARCHAR(50) addressLine2 VARCHAR(50) State VARCHAR(SO) country VARCHAR(50) postsCode VARCHAR(15) territory VARCHAR(10) Indexes Product Lines productline VARCHA Description VAR... Hol Description MED... image MEDIUMBLOB Indexes HI- 1 Customers customerlum be- INT(11) customerleme VARCHAR(50) contactLastName VARCHAR(50) contactFirst Lome VARCHAR(50) phone VARCHAR(50) addressiine VARCHAR(50) addressLine2 VARCHAR(50) city VARCHAR(50) state VARCHAR(50) postalCode VARCHAR(15) country VARCHAR(50) sslesRepEmployeumbe INT(11) creditLimL DOUBLE Indexes Employees employee umbe INT(11) lastName VARCHAR(50) firstherme VARCHAR(50) edersion VARCHAR(10) email VARCHAR(100) reports To INT(11) Job Tide VARCHAR(50) officeCode VARCHAR(10) - - 1 ++ Manages 1 1 HI Indexes Orders order Number INT(11) + order Date DATETIME requiredDote DATETIME tippedDate DATETIME status VARCHAR(15) comments TEXT customer Number INT(11) Order Details order Numbe- INT(1) productCode VARCHAR(15) + quantity Ordered INT(11) priceEsch DOUBLE orderline lumber SMALLINT(6) Indexes Products product Code VARCHAR(15) product Name VARCHAR(70) productscle VARCHAR(10) product'Vendor VARCHAR(50) product Description TEXT quentlyInStock SMALLINT(6) Buy Price DOUBLE MSRP DOUBLE productline VARCHAR(50) # Index Indexes