Computers and Technology, 25.02.2020 20:26 bella122805

Display a list of total quantity sold (label as TotSales) for each salesperson state and product finish. Null values for State should be substituted with ‘Unknown State’ and Null values for product finish should be substituted with ‘Unknown Finish’.
Display the customer ID and name for the customers who bought at least one product that belongs to product line Basic in March. List each customer once.
A. Now modify the above query to include the number of products bought that belongs to product line Basic in March.
B. Now restrict your results to those customers who have bought more than 2 such products
C. And now list all customers and for those customers that have never bought such product report 0. To do so you cannot just use an outer join (but you can try and this way you will see why not). To get this result you can use subqueries or you can use UNION, INTERSECT, or MINUS.
Display the order IDs for customers who have not made any payment, yet, on that order. Use the set command UNION, INTERSECT, or MINUS in your query
Display the names of the states in which customers reside but for which there is no salesperson residing in that state. Write this query two ways, using the set command UNION, INTERSECT, or MINUS and not using any of these commands.
List the Ids and names of those sales territories that have at least 50% more customers as the average number of customers per territory.
List the salesperson who has sold the most computer descs (Hint: you will need a subquery).
For each customer, list the customer ID, the number of orders from that customer, and the ratio of the number of orders from that customer to the total number of orders from all customers combined. (This ratio, of course, is the percentage of all orders placed by each customer.)
List the average of the number of customers per state (including only the states that are included in the Customer_T table). Hint: You are asked to find x in the statement: On average there are x customer in each state. You are not asked to report the number of customers in every state.

Answers: 1

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 12:50

You have just been hired as an information security engineer for a large, multi-international corporation. unfortunately, your company has suffered multiple security breaches that have threatened customers' trust in the fact that their confidential data and financial assets are private and secured. credit-card information was compromised by an attack that infiltrated the network through a vulnerable wireless connection within the organization. the other breach was an inside job where personal data was stolen because of weak access-control policies within the organization that allowed an unauthorized individual access to valuable data. your job is to develop a risk-management policy that addresses the two security breaches and how to mitigate these risks.requirementswrite a brief description of the case study. it requires two to three pages, based upon the apa style of writing. use transition words; a thesis statement; an introduction, body, and conclusion; and a reference page with at least two references. use a double-spaced, arial font, size 12.

Answers: 1

Answer

Computers and Technology, 22.06.2019 23:30

The next button in the review section shows the next available comment. next slide with no comment. previous comment. edited comment.

Answers: 1

Answer

Computers and Technology, 23.06.2019 22:20

Read “suburban homes construction project” at the end of chapters 8 and 9 (in the textbook) and then develop a wbs (work breakdown structure) in microsoft excel or in microsoft word (using tables)

Answers: 1

Answer

Computers and Technology, 24.06.2019 01:00

How can the temperature of a room be raised by 5degreesf?

Answers: 1

Answer

You know the right answer?

Display a list of total quantity sold (label as TotSales) for each salesperson state and product fin...

Questions