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

Explanation:

SELECT  

   distributor_id,  

   COUNT(*) AS TOTAL,  

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

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

FROM sometable;