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
Another question on Computers and Technology
Computers and Technology, 22.06.2019 10:30
Think about a recent customer service experience - either positive or negative. write a brief summary of that experience. now think about those four characteristics we look for in customer service representatives. how did the representative in your example stack up? write down your answer and give specific examples.
Answers: 1
Computers and Technology, 23.06.2019 14:30
Select the correct answer. sean is a computer programmer. he has programmed an application for toddlers that plays nursery rhymes. however, a logic error has occurred in the program. which problem is a likely consequence of the error? a. the program crashes every time the user wants to play the nursery rhymes. b. the program crosses its buffer boundaries and overwrites an adjacent program. c. the program plays a different nursery rhyme than the one the user intended to play. d. the program shows different structures in its programming language code. e. the program introduces new viruses every time the user plays a nursery rhyme.
Answers: 1
Computers and Technology, 23.06.2019 16:00
Write a grading program for a class with the following grading policies: a. there are two quizzes, each graded on the basis of 10 points. b. there is one midterm exam and one final exam, each graded on the basis of 100 points. c. the final exam counts for 50% of the grade, the midterm counts for 25%, and the two quizzes together count for a total of 25%. (do not forget to normalize the quiz scores. they should be converted to a percentage before they are averaged in.) any grade of 90 or more is an a, any grade of 80 or more (but less than 90) is a b, any grade of 70 or more (but less than 80) is a c, any grade of 60 or more (but less than 70) is a d, and any grade below 60 is an f. the program will read in the student’s scores and output the student’s record, which consists of two quiz and two exam scores as well as the student’s average numeric score for the entire course and final letter grade. define and use a structure for the student reco
Answers: 2
Computers and Technology, 23.06.2019 16:00
Helen is having a meeting with her colleagues in her company. they are working on the goals and objectives for the coming year. they want to ensure that these goals and objectives of the processes involved are properly evaluated. which system can helen and her colleagues apply to evaluate this? helen and her colleagues require a blank to evaluate the goals and objectives.
Answers: 2
You know the right answer?
Display a list of total quantity sold (label as TotSales) for each salesperson state and product fin...
Questions
Mathematics, 04.04.2020 05:24
Social Studies, 04.04.2020 05:25
Mathematics, 04.04.2020 05:26
