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, 21.06.2019 21:20

Your program will make use of long long int variables for all calculations. note: the use of long long int requires that you have c++11 support. you should have this automatically if you are using a newer version of visual studio. the support is there for gcc as well, but you may need the -std=c++11 or -std=c++0x compiler flag. you first need to read in the total number of seconds. there is no prompt for the read (that is, you just do the cin without using a cout to display a prompt). this is going to seem a little strange when you are running your program in your ide

Answers: 2

Answer

Computers and Technology, 22.06.2019 05:00

This program will store roster and rating information for a soccer team. coaches rate players during tryouts to ensure a balanced team. (1) prompt the user to input five pairs of numbers: a player's jersey number (0 - 99) and the player's rating (1 - 9). store the jersey numbers in one int vector and the ratings in another int vector. output these vectors (i.e., output the roster). (3 pts) ex: enter player 1's jersey number: 84 enter player 1's rating: 7 enter player 2's jersey number: 23 enter player 2's rating: 4 enter player 3's jersey number: 4 enter player 3's rating: 5 enter player 4's jersey number: 30 enter player 4's rating: 2

Answers: 1

Answer

Computers and Technology, 22.06.2019 17:00

Match the following. 1. show grouping of word processing tasks that can be performed quick access toolbar 2. shortcut location for commonly used elements scroll bars 3. organized commands used to modify documents ribbon 4. used to align and measure content in a word screen zoom bar 5. vertical and horizontal bars that are used to navigate through a document contextual tabs 6. displays the name of the document in use ruler 7. allows users to enlarge or shrink a visual of a word document title bar

Answers: 2

Answer

Computers and Technology, 22.06.2019 22:30

Write a full class definition for a class named player , and containing the following members: a data member name of type string .a data member score of type int .a member function called setname that accepts a parameter and assigns it to name . the function returns no value.a member function called setscore that accepts a parameter and assigns it to score . the function returns no value.a member function called getname that accepts no parameters and returns the value of name .a member function called getscore that accepts no parameters and returns the value of score .this is what i have, aparently this is wrong: class player{private: string name; int score; public: void player: : setname (string n){name =n; }void player: : setscore (int s){score = s; }string player: : getname (){return name; }int player: : getscore (){return score; }};

Answers: 2

Answer

You know the right answer?

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

Questions