Question: Please submit your answer either in SQL code: The following questions are based on the sample database provided on W3schools.com (30 points in total, 3points/each

Please submit your answer either in SQL code:

The following questions are based on the sample database provided on W3schools.com (30 points in total, 3points/each except Q.9).

1. Find out the total number of orders (NumberOfOrders) made by each customer (customerID, customerName, city, country), including those who did not make any order, and sort the result by customerID.

2. Find out the total number of orders (NumberOfOrders) made by each customer (customerID, customerName, city, country), not including those who did not make any order, and sort the result by customerID.

3. Find out the total number of orders (NumberOfOrders) made by each customer (customerID, customerName, city, country) who are not from USA and made no less than 3 orders, and sort the result first by country and second by NumberOforders in descending order.

4. Find out the total number of orders (NumOrdersShipped) shipped out by each shipper (shipperID, name, phone), and sort the result by NumOrdersShipped in descending order.

5. Find out suppliers (SupplierID, name, city, country, and phone) who are from either Germany or USA, and supplying no less than 3 products. Order the result by country.

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 Databases Questions!

Please submit your answer either in SQL code: The following questions are based on the sample database provided on W3schools.com (30 points in total, 3points/each except Q.9). 6. What is the total...

Please submit your answer either in SQL code: The following questions are based on World sample database provided by MySql server (30 points in total, 3points/each except Q.17 & Q.18). 15. Find out...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

I need the following homework exercise completed. All of the information is within the attached files. I require no explanations, just the answers. Part 1: Finding information: Each of the following...

Part 1: Finding information: Each of the following questions should be answered within the table provided in file entitled "PART 1 TABLE." American Eagle's 2009 10-K is in the file entitled...

Answer the following questions about an organization, based on the Sample Form 990 below. A. Provide: Total revenue Total expenditures End-of-year cash balance Public support percentage Fundraising...

ANNOTATION OF A QUANTITATIVE RESEARCH ARTICLE Submit: Annotation of a Quantitative Research Article This week, you will submit the annotation of a quantitative research article on a topic of your...

Please help me solve the following! (I will rate your answer 5 stars Case Analysis: There are three parts of questions in total, and all the following questions are based on the case. Cory Rogers of...

I need help with this essay. Performing tax research to find correct answers to a given tax situation and composing memoranda summarizing these findings are important parts of tax practice. As...

Practice Section You may want to download and open the Practice Database in Lesson 4 in Microsoft Access (Admissions Student Database.mdb; Please note that this database is graciously provided...

As an extension of 15-26, assume that at the end of the year, management of Patel and Sons, Inc., decides that the overhead variances should be allocated to WIP Inventory, Finished Goods Inventory,...

Questions :- Anne loaned her friend Aaron $8,000. He repaid her with $8,500 twelve months later. What amount must Anne include in her income tax return for the year? A. $600 B. $8,500 C. $500 D. Nil

1 2 . 1 3 . 1 4 . 1 5 . 1 6 . 1 7 . 1 8 . 1 9 . 2 0 . 2 1 . 2 2 . 2 3 . 2 4 . 2 5 . 2 6 . 2 7 . 2 8 . 2 9 . 3 0 . 3 1 . 3 2 . 3 3 . 3 4 . 3 5 . 3 6 . Question Workspace Considered alone, which of the...

short answer Define the techniques and ideals of Naturalism as a literary movement. Demonstrate how they appear in Norris's "A Deal in Wheat

3-13 Use the value chain and competitive forces models to evaluate the impact of the Internet on book publishers and book retail stores such as Barnes & Noble. Borders Group (including many former...

3-14 How did Barnes and Noble change its business model to deal with the Internet and e-book technology? Borders Group (including many former Waldenbooks rebranded as Borders Express) liquidated its...

3-10 In this exercise, you will use database software to analyze the reservation transactions for a hotel and use that information to fine-tune the hotels business strategy and marketing activities....