Question

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.

Answer 1

Step-by-step explanation:

SELECT

distributor_id,

COUNT(*) AS TOTAL,

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

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

FROM sometable;