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

Write SQL for each question by using the tables below .

CUSTOMERS TABLE

Write SQL for each question by using the tables below .

OFFICES TABLE CUSTOMERS TABLE OFFICES TABLE 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

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- How many salespeople exceeded their quota? 2- How many orders are over $25,000? 3- Find...

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 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 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 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...

single SQL script Through the script, create normalized tables (using CREATE TABLE) with constraints, following the process of normalization up to 4NF. The tables need to be linked through SQL code,...

Write the queries necessary to obtain the required information. Make sure all columns you return have descriptive column headings. You must show the result of the query. For example, if the query is:...

Preferred stock is considered to be nonparticipating because: a. Investors do not participate in the election of the firms directors. b. Investors do not participate in the determination of the...

Prepare the adjusting entry to record bad debts under each separate assumption. No Required information [The following information applies to the questions displayed below.] At December 31, Hawke...

Question 1 3 jaundice... is very rare and often fatal. is very rare and usually requires surgery to correct it . is common and always goes away on its own, so it's not really a concern. is common and...

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

4. To what extent do you think measures of a countrys wellbeing should be included when comparing the performance of countries? Should there be something like the balanced scorecard, discussed in...

2. In your opinion do you think that measures of social performance should be considered when deciding managers pay? If so what measures should be used?

2. Obtain a copy of the safety policy for either your college or your workplace. a. Use this to identify the roles of various people in the organisation in relation to health and safety. b. Use the...