Question: What are the SQL statements for the below questions? Must be able to insert into w3schools.com and get results. 1. List the top 3 customers
What are the SQL statements for the below questions? Must be able to insert into w3schools.com and get results.
1. List the top 3 customers who placed the most orders that are shipped by United Package. (You need output both customer names and number of orders they placed.)
2. For each shipper name, list the number of orders (shipped) containing any product supplied by city of Boston in USA. Sort your results by number of those orders descendingly.

Tables Structure and their first two rows. OrderDetails Order DetaillD OrderID ProductID Quantity Products - 9 9 ProductID Product Name Supplier CategoryID Unit Suppliers D. Supplier SupplierName ContactName Address City Postal Code Country Phone Price Categories CategoryID CategoryName Description Orders - OrderID 9 Customer EmployeeID Order Date Shipper Customers 0-9 CustomerlD CustomerName ContactName Employees Employeeld LastName First Name BirthDate Photo Address City PostalCode Country Notes Shippers ShipperID Shipper Name Phone
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
