katrinajernae5639 katrinajernae5639
  • 31-07-2020
  • Computers and Technology
contestada

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.

Respuesta :

Manetho
Manetho Manetho
  • 31-07-2020

Explanation:

SELECT  

   distributor_id,  

   COUNT(*) AS TOTAL,  

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

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

FROM sometable;

Answer Link

Otras preguntas

Chris has a six sided die. Create a sample space of possible outcomes for rolling a number. Is this simple or compound event
Which statement best describes the circular flow of an economy? the flow between businesses and resources the exchange of money, goods, and services in an econo
What was the Holocaust, and how did it occur? Why do we remember it? How did victims and survivors respond, and how can we honor their voices? How did the peopl
Select all the expressions that are solutions to 9 = 1/3x
HELP IVE GOT 5 MINS!!
what is the difference between 2/4 and 4/9
1. The agreement between Russia and France was intended to counter which alliance? HELP
a story that ends with time must tell​
What are some of the definitions of a franchise?
Which graph best represents f(x)=6(3)x. PLEASE