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.

What are the SQL statements for the below questions? Must be able

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!