Ask question

Ask question

All categories

3 years ago

15

Use ONE SQL statement to show the total number of actual hours for each customer. In the output, show customer id and the total

number of actual hours for each customer.

Computers and Technology

1 answer:

valkas [14]3 years ago

7 0

Explanation:

SELECT

distributor_id,

COUNT(*) AS TOTAL,

COUNT(IF(level='exec',1,null)),

COUNT(IF(level='personal',1,null))

FROM sometable;

You might be interested in

In what century was plastic invented ?

Angelina_Jolie [31]

in the year 1907 plastic was invented

5 0

3 years ago

Who benefits the most from billing by the second for cloud resources, such as virtual machines?.

scoundrel [369]

Clients that run numerous virtual machines.

<h3>What is a virtual machine?</h3>

A virtual machine is the virtualization or emulation of a computer system in computing.
The functionality of a physical computer is provided by virtual machines, which are built on computer architectures.
Their use may necessitate specialized hardware, software, or a combination of both.
Virtual machines' primary function is the simultaneous operation of several operating systems on a single piece of hardware.
Without virtualization, running two different physical units would be necessary to run different operating systems, such as Windows and Linux.
Through the use of virtualization technologies, virtual machines are made possible.
Multiple virtual machines (VMs) can run on a single machine thanks to virtualization, which simulates virtual hardware using software.
The real machine is referred to as the host, and any virtual machines running on it as the guests.

To learn more about virtual machines, refer to:

brainly.com/question/27961159

#SPJ4

7 0

1 year ago

A family member who hasn’t worked with computers before has decided to change jobs. You’ve been asked to explain some of the bas

Olin [163]

Answer: That due to the specific tasks that needs to be accomplished by each program to make an all encompassing program would be inefficient and full of bugs

Explanation: try to do something along those lines ex why would MySQL be used to check your essay for grammar the tasks are on opposite spectrums

8 0

3 years ago

Why does angular page look different after refresh.

alukav5142 [94]

Most of the web applications are written with SPA frameworks such as Angular, React, Vue.js, etc. The problem with these SPAs is that the single page is loaded in the browser once and then the framework will take care of all the routing among pages and gives the impression to the user that it is a multi-page application. When you refresh your page in the browser that single page called index.html is reloaded and you will lose the entire state of the application.

3 0

3 years ago

If your computer will not turn on, what is something you would do to diagnose the problem?

laiz [17]

I would hold down the power button for about 10 seconds, and then try pressing the power button again.

If you are using a desktop, try unplugging it and then plugging it and plugging it back in again. Then try pressing the power button again. If this does not work, then unplug your computer again, but now plug in something else into the same spot, like a lamp, or a phone charger, and see if they work. If they do not work, then it is the power outlet that is broken, not your computer. If they do work, then there is most likely something wrong with your computer or your power cord. Try powering on your computer using a different power cord. If this does not work, you should take your computer some where to get it checked, and fixed, if necessary.

If you are using a laptop, try charging it, and then hold down the power button for about 10 seconds, and then try pressing the power button again. if this does not work, you should take your computer some where to get it checked, and fixed, if necessary.

8 0

3 years ago