What is thesql command to list the total sales by customer , month , and product, with subtotals by customer and by month and a grand total for all product sales

Answers

Answer 1

Answer:

The answer is below

Explanation:

The the sql command to list the total sales by customer , month , and product, with subtotals by customer and by month and a grand total for all product sales is:

SELECT S.CUS_CODE, T.TM_MONTH, S.P_CODE,

SUM(S.SALE_UNITS*S.SALE_PRICE) AS "TOTSALES"

FROM DWDAYSALESFACT AS S INNER JOIN DWTIME AS T ON S.TM_ID =

T.TM_ID

GROUP BY S.CUS_CODE,T.TM_MONTH,S.P_CODE WITH ROLLUP;


Related Questions

solve each of the following a. 3x=27 ​

Answers

Answer:

3^(x)=27     x=3

Explanation:

3x3x3 27

:)

3ˣ = 27

Factorise 27.

27 = 9 × 3

27 = 3 × 3 × 3

27 = 3³

So,

3ˣ = 27

=》ˣ = ³

3³ = 27

_____

Hope it helps ⚜

about how many smart devices are active today coinbase

Answers

Considering the latest information released by Statisticà, the number of active smart devices in the world today is 21.5 billion.

What is Smart Device?

Smart Device are generally known as electronic devices, that have the capacity to connect with other device or networks through wireless servers like Bluetooth, Zigbée, NFC, Wi-Fi, LiFi, 5G, etc.

Examples of Smart Devices

Smart devices generally include the following:

SmartphonesSmart cars Smart doorbellsSmart refrigeratorsTabletsPCSmart watches, etc.

Hence, in this case, it is concluded that the correct answer is 21.5 billion.

Learn more about Smart Device here: https://brainly.com/question/24803254

what computer is designed for particular application​

Answers

Answer: Applications for desktop or laptop computers are sometimes called desktop applications, while those for mobile devices are called mobile apps. When you open an application, it runs inside the operating system until you close it

Explanation:

Which of the following programming scenarios would benefit most from the use of lists?

Answers

The programming scenarios which would benefit most from the use of lists is: B. writing a program to calculate statistics about a large set of exam scores (e.g highest/lowest score, median average score).

Computer programming involves the process of designing and developing an executable instructions (codes) or collection of data to perform a specific task.

In Computer programming, a list can be defined as an abstract data type that represents a finite number of either ordered or unordered values. Thus, a list can be used to perform the following tasks:

Store data items.Delete data items.Add data items.

A computer program that is used to calculate statistics about a large set of exam scores (e.g highest/lowest score, median average score) would benefit most from the use of lists because it comprises a set of numerical values that can be sorted in either an ordered or unordered array.

Read more on lists here: https://brainly.com/question/15092271

what method does a gsm network use to separate data on a channel?

Answers

It uses TDMA method

You are creating a program that can add up the amount of money the user spent that day. Right down to the penny! What kind of variables should you create? a default variable a user variable an integer variable a float variable

Answers

Answer:A. A default Variable

Explanation:

Answer:

A

Explanation:

Did it on a Test

Your grandmother tells you a dollar doesn't go as far as it used to. She says the "purchasing power" of a dollar is much less than it used to be. Explain what she means. Try to use and explain terms like inflation and deflation in your answer. ​

Answers

Answer:

The obtaining influence of a dollar is substantially less on the grounds that more cash is made and causes the value of the dollar greenback to diminish, making things increasingly costly. This is called swelling. In any case, when less cash is made, the value of a dollar greenback increments and things turn out to be more affordable. This is called flattening. As the years go on, the purchasing power of a dollar decreases and decreases.

Hope that helps. x

once multiple layers are selected which keyboard shortcut merges them

Answers

Considering the computer system analysis, when the multiple layers are selected, the keyboard shortcut that merges them is "Ctrl+E for (Windows) or Command+E for (Macbook)."

What Keyboard Shortcut?

Keyboard Shortcut combines keyboard keys to ensure software programs perform specific functions.

Keyboard Shortcuts can be made by a Computer manufacturer as part of the standard functionality of the operating system or application program or made explicitly by the user in a scripting language.

Keyboard Shortcut is different in both Windows and Macbook Operating systems.

Hence, in this case, it is concluded the correct answer is "Ctrl+E for (Window) / Command+E for (Macbook)."

Learn more about Keyboard shortcuts here: https://brainly.com/question/14447287

In the earliest stages of human history, what was the only medium?
ink
books
the human body
magazines

Answers

The only medium that was used for the dissemination of information during the earliest stages of human history is: C. the human body.

Information sharing is an integral part of human life because no human is able to live comfortably in isolation without the need to share or receive messages from others through a particular medium, especially for awareness, growth, development and proper decision making.

Prior to the medieval period, which is the earliest stage of human history, the human body serve extensively as the only medium that was used for the dissemination of information from one person to another.

This ultimately implies that, various symbols, signs and objects that were  mutually understandable to the people were drawn or written on human body, so as to serve as a medium during the process of communication.

Read more: https://brainly.com/question/14810228

Pls help me pls I’m struggling

Answers

Answer:Turn Right () Degrees (block)

The turn right () degrees block is a Motion block and a stack block. The block turns its sprite's direction the specified amount of degrees clockwise.

What is the main difference between structured and unstructured data?

Answers

Answer:

answer is 4.

Explanation:

for an instance let's say you've got to make list of students who would stay after school for sports.then you have to collect data such as Student name _gender _the sport he or she will attend to. Then you get three columns of table to do that when you write those you can get a clear information seeing those data..

List three (3) features of first generation computer
PLEASE HELP!!!!!

Answers


Features of first generation computers:

Technology used: vacuum tube.

Machines languages were used to instruct the computer.

Magnetic core memory was used as primary memory.

Electrostatic tubes, Parer tape, punch card, magnetic tape.

A(n) ________ is a heavily secured server located between a company's secure internal network and its firewall.

Answers

Answer: bastion host

Explanation:

What do software engineers use as tools to provide automated support for the development of the system

Answers

Answer: CASE

Explanation:

which subunit of a heterodimeric cdk is the regulatory subunit?

Answers

The answer is cyclin subunit

what information about a cisco router can be verified using the show version command?

Answers

- the routing protocol version that is enabled.
- the value of the configuration register.
- the operational status of serial interfaces.
- the administrative distance used to reach networks.

Which type of wireless attack is designed to capture wireless transmissions coming from legitimate users

Answers

A type of wireless attack that is typically designed and developed to capture wireless transmissions coming from legitimate end users is referred to evil twin.

An evil twin can be defined as an illegitimate and fraudulent that is usually set up to capture wireless transmissions, especially by eavesdropping on the information transmitted by legitimate end users.

In Cybersecurity, an evil twin is an equivalent of phishing on a local area network (LAN).

Basically, an evil twin is a rogue wireless access point (AP) that is typically designed and developed to capture wireless transmissions and sensitive information coming from legitimate end users.

In conclusion, an evil twin is used by an attacker or hacker to gain an unauthorized access to sensitive information from legitimate end users.

Read more: https://brainly.com/question/5660386

3.) The primary storage device that holds the data currently being processed by the computer is​

Answers

Computer memory I hope it works

Answer:

I personally think its a hard drive or something like that,im not a computer expert to be honest

difference between boot disk and booting in 5 points​

Answers

[tex]Answer \: -[/tex]

In computing, booting is the process of starting a computer. It can be initiated by hardware such as a button press, or by a software command. After it is switched on, a computer's central processing unit (CPU) has no software in its main memory, so some process must load software into memory before it can be executed. This may be done by hardware or firmware in the CPU, or by a separate processor in the computer system.

A boot disk is a removable digital data storage medium from which a computer can load and run an operating system or utility program. The computer must have a built-in program which will load and execute a program from a boot disk meeting certain standards.

Which of the following would be the most appropriate way to define a method that calculates and returns the final price, after tax and tip, for a passed in price, assuming tip is always 15% and tax is always 8%?

a. public double getFinalPricel double tips, double tax).
b. public double getFinal Price double tax)
c. public double getFinalPrice/double basePrice, double tips)
d. public double getFinalPrice double basePrice, double tips, double tax)

Answers


D. I hope it helped

To gain access to the functions and variables of a library module, use a(n) _________ statement. A. import B. export C. global D. library

Answers

Answer: import

Explanation:

lenny joggy along a trail for 1.35 hours he ran at a pace of 3.2 miles per hour. how far did lenny jog?

Answers

Answer:

Lenny jogged along a trail for 1.35 hours. He ran at a pace of 3.2 miles per hour. How far did Lenny jog? Answer Lenny jogged 4.32 miles.

Explanation:

The software which manages environment for running programs handling error controlling devices configuring the computer system and managing the resources of a computer.
Write the technical term of the given question of the picture .
Correct Answer =⟩ Thanks
Best answer =⟩ Brainliest
Random answer =⟩ Reported and deleted ​

Answers

Answer:

D

Application

System software is the set of programs that enables your computers hardware devices and Application software to work together.

Practical computer systems divide software systems into two major classes: System software: Helps run the computer hardware and computer system itself. System software includes operating systems, device drivers, diagnostic tools and more. ... (Some application software is pre-installed on most computer systems.)

Explanation:

According to popular science Web sites, the scientific process of digital forensics normally starts with a(n) ________.

Answers

Answer:

a hypothesis that forms into a question.

Explanation:

Brianna is taking a backpacking trip in the wilderness and wants to back up the photos from her camera. Which type of storage device would be best for this purpose?
A. Optical disc
B. Cell phone
C. Flash drive
D. HDD

Answers

Answer:

C

Explanation:

Flash drives usually have an input (E.G. one of those android charger connectors), so just plug that into your camera, and load the flash drive with the photos. Then go home and plug the USB on the flash drive into your PC. If there isn't already, a folder will be made in your "Pictures" folder on your PC, to which you can open the folder, and then your photos should be there. From there you can open them, print them, etc.

Hope this helped, and sorry if I didn't answer in time.

Brake fluid is made up of a chemical that:​

Answers

hi there!

Brake fluid is a type of hydraulic fluid used in hydraulic brake and hydraulic clutch applications in automobiles, motorcycles, light trucks, and some bicycles. It is used to transfer force into pressure, and to amplify braking force. It works because liquids are not appreciably compressible.

hope this helps.

Can someone please help

Answers

Answer:

Explanation:

la reponse est le premier et le 3 eme pointcar en effet le premier point c est logiqye e le 2 e aussi  

A facility that is pre-wired for necessary telecommunications and computer equipment, but doesn't have equipment installed, is known as a

Answers

Answer:

hot site

Explanation:

Question 11
Methods that return a decimal value must be declared using what type?


a. int

b. void

c. double

d. String

e. null


Question 12

Which of the following is true when x = 15?


a. (x >= 15) && (x < 13)

b. !(x > 13) || (x > 16)

c. (x > 13) && (x < 17)

d. (x < 15) || (x > 15)

e. (x <= 13) || (x >= 17)

Answers

Answer:

11. a, 12.c

Explanation:

bc numbers must be declared as ints and 15 is greater than 13 but lesser than 17

This is an image of the ...........................Topology.

if answer Correct i will mark the first person brainly.​

Answers

Answer:

Mesh

Explanation:

Other Questions
Im so mad I have this whole exam but does anybody know this one? A 1 liter solution contains 0.370 M hypochlorous acid and 0.493 M sodium hypochlorite. Addition of 0.092 moles of barium hydroxide will: (Assume that the volume does not change upon the addition of barium hydroxide.) Altoon Manufacturing's records were partially destroyed in a flood. The company does not know what sales have been for the year, but it does know all sales were on account. Also, the beginning accounts receivable balance was $19,000, and its accounts receivable balance at the time of the flood was $25,000. From the beginning of the year until the flood, cash collections from credit customers were $158,000. Given this information, what are Altoon Manufacturing's sales for the year until the flood?a. $164,000b. $114,000c. $202,000d. $209,000e. $189,000 what dose analyzing the use of magical elements in a magical realist story often help the reader discover PLZZZZZZ HELP! Find the area. Oceans currents are in constant motion. What are some of the effects of these currents? Timothy has 72 coins, consisting of quarters, dimes, nickels, and 8 pennies. Samantha comes and takes all of his quarters, takes 3 of his dimes, takes 2 of his nickels, and leaves him with one penny, leaving him with 45 coins. What is the value of quarters that Samantha took? Can someone explain how to solve this problem? what is life and pls explain ? please help, will give brainliest!!!! difference between chromosomes and DNA It is necessary to make 225 mL of 0.222 M solution of nitric acid. Looking on the shelf, you see only 16 M nitric acid. How much concentrated nitric acid is required to make the desired solution? When driving SUV it is recommended to place your thing Hot air is to be cooled as it is forced to flow through the tubes exposed to atmospheric air. Fins are to be added in order to enhance heat transfer. Would you recommend attaching the fins inside or outside the tubes? Why? When would you recommend auaching fins both inside and outside the tubes? An increase in the biodiversity of an ecosystem leads to an increase in its productivity. True False Am I thirsty? I am I think so Ransom Widgets allocates the estimated cost of its accounting department, $200,000, to its production and sales departments since the accounting department supports these departments with regard to payroll and accounts payable functions. The accounting department costs will be allocated based on the number of employees using the direct method. Information regarding employees follows: Department EmployeesAccounting 4Production 36Sales 12How much of the accounting department costs will be allocated to the production and sales departments, respectively?a. Production Sales $150,000 $50,000b. Production Sales $180,000 $60,000c. Production Sales $1,800,000 $600,000d. Production Sales $22,222 $66,667 3. The politician _____ to admit that we had done anything wrong.A. denied B. accepted C. refused D. explained Summarize the central ideas of the article on the lines below in no more than two sentences. Article : Freuds Theory of the ID, Ego, and Superego I don't need to study .... at university to become a famous actor Which expression is equivalent to 6x3 + 3y2 5x3 + 2y2?