Computers and Technology, 25.05.2021 01:00 tarabrett8863

List in alphabetical order of names of customers with more than $10 million in annual revenue Give names and average monthly revenue of customers having annual revenue exceeding $20 million. Name the column Average_Monthly_Revenue with a literal (note the underscores). (Hint: Use division.)
What are the truck ID’s of trucks that have carried small shipments. Small shipments are defined as those that weigh less than 800 pounds? (HInt: Avoid duplcates.)
Give names of all customers whose type is not retailer or wholesaler and who have over $20 million in annual revenue. Use the NOT IN keywords.
To what cities have customers with revenue less than $5 million sent shipments? (Hint: Avoid duplicates.)
For each customer (cust_id and cust_name) with annual revenue under $10 million, and whose shipments average more than 5000 pounds, what is the total weight of shipments they’ve sent? Label the total column as Total_Weight. (Hint: Requires Having.)
What is the total weight of shipments that the Mack trucks have carried? (Truck make is 'Mack'.) Label the answer column as Total_Loads.

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 23.06.2019 00:10

Write a function so that the main0 code below can be replaced by the simpler code that calls function mphandminutes tomiles0. original main0 int main) l double milesperhour-70.0; double minutestraveled = 100.0; double hourstraveled; double milestraveled; hourstraveled = minutestraveled / 60.0; milestraveled = hourstraveled * milesperhour; cout < "miles" 2 using namespace std; 4 /* your solution goes here/ 6 int maino 1 test passed 7 double milesperhour 70.0 all tests passed 8 double minutestraveled 100.0; 10 cout < < "miles: " < < mphandminutestomiles(milesper-hour, minutestraveled) < < endl; 12 return 0; 13

Answers: 1

Answer

Computers and Technology, 23.06.2019 02:00

Arecipients list has been loaded into a document. which commands should be clicked in order to filter the list so that letters will not be printed for recipients who live in a certain state? mailings tab, start mail merge, select recipients, type new list, then insert only contacts from the desired states mailings tab, rules, select recipients, use existing list, then choose a recipients list that includes only contacts in certain states mailings tab, select recipients, use existing list, rules, fill in, then type in certain states mailings tab, rules, skip record select “state” under field name, then type in the state name under “equal to”

Answers: 2

Answer

Computers and Technology, 23.06.2019 02:30

What is the power dissipated by a resistor with a current of 0.02 a and a resistance of 1,000 ? a. 200 w b. 20 w c. 0.4 w d. 4 w

Answers: 1

Answer

Computers and Technology, 23.06.2019 11:00

What are the possible consequences of computer hacking? what is computer piracy? describe some examples. what are the effects of computer piracy? what are the possible consequences of computer piracy? what is intentional virus setting? describe some examples. what are the effects of intentional virus setting? what are the possible consequences of intentional virus setting? what is invasion of privacy? describe some examples. what are the effects of invasion of privacy? what are the possible consequences of invasion of privacy? what is an acceptable use policy and what is the purpose of the acceptable use policy what is intellectual property and how can you use it?

Answers: 1

Answer

You know the right answer?

List in alphabetical order of names of customers with more than $10 million in annual revenue Give...

Questions