1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
olasank [31]
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
Create a story that depicts the events leading up to a vehicle crash fatality, the crash itself, and the emotional aftermath on
Brilliant_brown [7]

Answer:

About 5 years ago my girlfriend and I were taking a summer camping trip in southern Alberta. I was in the passenger seat trying to find the campground on a map when she drove over the crest of a hill, was blinded by the sun drove into the ditch. It was a seriously steep ditch but we weren't going very fast so all was fine. I looked over at her and laughed before returning my attention to the map, assuming she could safely bring the vehicle back onto the road.

The next thing I knew, the SUV launched onto the pavement and she lost control and we began swerving. I remember feeling the wheels on the driver's side lift off the ground, then the impact as I was slammed into the door and glass exploded into my face. We barrel rolled and we rolled over-front for a seriously long way.

At some point during the chaos I looked over at her to make sure she was "ok", and just as I did so I watched as she was thrown into the ground through her door window and the corner of the roof just above her seat was crushed inward. The way it looked to me was that she had just been crushed between the ground and the roof of the vehicle. I passed out at that point.

When I came to I had somehow already unbuckled myself from my seat and the vehicle was on its roof. I crawled over to her seat and was in absolute shock to see that she was still in one piece. I removed her from her seat and got us out through the windshield before carrying her for about a half a kilometer down the road, still in shock and fueled entirely by adrenaline.

We were found by a driver who had gone past the wreckage and we were eventually taken to a hospital. I broke 3 ribs on my right side and dislocated my right shoulder, she was severely concussed and scraped up but otherwise mostly okay. However she was 7 weeks pregnant at the time and we found out while in hospital that her body had rejected it under the immense and sudden stress.

We are still together and have 3 amazing and beautiful children, but she still holds onto a lot of guilt surrounding the accident and the loss.

Explanation:

4 0
3 years ago
The ability for a protocol or program to determine that something went wrong is known as_________.
777dan777 [17]

Answer:

The correct answer to the following question will be Error-detection.

Explanation:

Error-detection: The detection of errors caused during the transmission from the transmitter to the receiver by damage and other noises, known as Error-detection. This error-detection has the ability to resolute if something went wrong and if any error occurs in the program.

There are mainly three types of error-detection, these types can be followed:

  • Automatic Repeat Request (ARQ)
  • Forward Error Correction
  • Hybrid Schemes

There are two methods for error-detection, such as:

  • Single parity check
  • Two-dimensional parity check

4 0
3 years ago
How to see if your computer has bluetooth?
RUDIKE [14]
Assuming you're running Windows, click the start button, and then search for "Device Manager" (or open CMD or PowerShell and type devmgmt.msc). Look at the list of devices. If Bluetooth is there, you have it; if it's not there, you don't. 
3 0
3 years ago
Consider the classes below, declared in the same file: class A { int a; public A() { ​ a = 7; } } class B extends A { int b; pub
DiKsa [7]

Answer:

2. <em>A reference of type A can be treated as a reference of type B</em> - False

Base class or its objects are not related to their derived class (or its objects).

Explanation:

class A {

   int a;

   public A() {

       a = 7;

   }

}

class B extends A {

   int b;

   public B() {

       b = 8;

   }

}

///////////////////////////////////////////////////////////////////////////////////////////////////////

1. <em>After the constructor for class B executes, the variable a will have the value 7 </em>- True.

When an object of a derived class is declared, the constructor of base class is called before the constructor of derived class (is called).

3. <em>Both variables a and b are instance variables </em>- True.

Classes can have instance, or member, variables and methods.

4.<em> After the constructor for class B executes, the variable b will have the value 8</em> - True.

When object of class B is declared, its constructor was called, which initialized variable b to 8.

4 0
4 years ago
Type size in a textbook may be used to indicate the relative importance of ideas.
Alborosie
Yes true 

hey is this one of your questions on a science packet if so it is called explore ring Earth's surface because I have the same packet with the same question on it
3 0
3 years ago
Read 2 more answers
Other questions:
  • Your dad just purchased a new desktop with Windows 8 Professional. He is calling you, informing you that he is unable to remote
    9·1 answer
  • In internet terminology, what is the term, .com, called?
    12·2 answers
  • Computers are not just stand-alone desktop machines anymore. They are often embedded in common appliances and technology that we
    6·1 answer
  • Program Rock.java contains a skeleton for the game Rock, Paper, Scissors. Open it and save it to your directory. Add statements
    10·1 answer
  • Kyle wants to access his school’s home page. How can he do this?
    8·2 answers
  • 15 Points ASAP
    14·2 answers
  • How do I contact an admin
    8·1 answer
  • Please answer me <br> in Assignment - Algorithms
    10·1 answer
  • How was science used to make television?
    6·2 answers
  • You can put ______ on your phone.
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!