Question: Write SQL for each question by using the tables below . CUSTOMERS TABLE OFFICES ORDERS PRODUCTS SALESREPS 1- How many salespeople exceeded their quota? 2-

Write SQL for each question by using the tables below .

CUSTOMERS TABLE

Write SQL for each question by using the tables below . CUSTOMERS

OFFICES

TABLE OFFICES ORDERS PRODUCTS SALESREPS 1- How many salespeople exceeded their quota?

ORDERS

2- How many orders are over $25,000? 3- Find the average order PRODUCTS

amount, the total order amount, the average order amount as a percentage SALESREPS

of the customer's credit limit and the average order amount as a

1- How many salespeople exceeded their quota? 2- How many orders are over $25,000? 3- Find the average order amount, the total order amount, the average order amount as a percentage of the customer's credit limit and the average order amount as a percentage of the sales representative's quota? 4- What is the quota range assigned in each office? (Max - min according to sales personnel) 5- How many salespeople work in each office? 6- How many different customers are served by each salesperson? 7- List the total order amount for each customer of each salesperson? 8- Calculate the total order of each salesperson? 9- What is the average order size for each salesperson with orders totaling more than $30000? 10- For each office consisting of two or more people, calculate the total quota and total sales of all salespeople working in the office?

* (New)

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!

Write SQL for each question by using the tables below . CUSTOMERS TABLE OFFICES ORDERS PRODUCTS SALESREPS 1) List the names of the sales offices, their targets and their actual sales? 2) List the...

Write SQL for each question by using the tables below . CUSTOMERS TABLE OFFICES ORDERS PRODUCTS SALESREPS 31) Find the salesperson who has not yet been assigned to an office? 32) List the salespeople...

Write SQL for each question by using the tables below . CUSTOMERS TABLE OFFICES ORDERS PRODUCTS SALESREPS 1) List all salespeople who are under quota but whose sales are not less than $150,000? 35)...

Write SQL for each question by using the tables below . CUSTOMERS TABLE OFFICES ORDERS PRODUCTS SALESREPS 1) List orders over $25,000 showing the name of the customer who placed the order, the...

Write SQL for each question by using the tables below . CUSTOMERS TABLE OFFICES TABLE 1- How many salespeople exceeded their quota? 2- How many orders are over $25,000? 3- Find the average order...

Write SQL for each question by using the tables below CUSTOMERS OFFICES ORDERS PRODUCTS SALESREPS 1) Show the price in the order, the quantity on hand, and the total quantity for each item where the...

Write an SQL query to insert four new records into the orders and customers tables using the following data: Customers Table CustomerID FirstName LastName StreetAddress City State ZipCode Telephone...

1. Casel Ivana's Ice Cream just finished its first six months of manufacturing and selling ice cream. The company has two main product lines, Ice cream cups and ice cream bars, both of which are...

Help me with the homework i am stuck. (Total: 30 points) Part A: Answer the following questions as comments in your sql file. I suggest you write the answers in a WORD document and then copy them to...

What are some differences between a subprime loan and a traditional loan? What is the difference between an MBS and a CDO?

Ferrari with a mass of 1400 kg approaches a freeway underpass that is 10m across. At what speed must the car be moving, in order for it to have wavelength such that it might somehow diffract after...

Use solver in excel to find the most profitable itinerary for the ships maiden voyage Titanic Cruise Company Daily Shore Daily Daily Daily Fuel Daily Labor Daily Supplies Port Excursion Docking Local...

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

4. Identify cultural variations in communication style.

9. Understand the phenomenon of code switching and interlanguage.

8. Explain the difference between translation and interpretation.