SQL

1. (use SUBQUERY) List the name, city, state, country, credit limit, and total products ordered for the top 3 customers who ordered the most products.

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