pareto, MySQL - rextester

Language: Layout:

create temporary table runtable(id int, time date, operation text);
create temporary table pareto(run_id int, pareto.failure text);
insert into runtable values (1,'2016/01/05','d')
                           ,(1,'2016/06/01','d')
                           ,(1,'2016/07/01','d')
                           ,(2,'2016/01/01','hr')
                           ,(2,'2016/03/01','hr');
insert into pareto values (1,'failure 1')
                         ,(2,'failure 2');

SELECT 
    runtable.operation,
    pareto.failure,
    COUNT(CASE WHEN MONTH(runtable.time) = 1 THEN 1 else NULL end) as 'Jan',
    COUNT(CASE WHEN MONTH(runtable.time) = 2 THEN 1 else NULL end) as 'Feb',
    COUNT(CASE WHEN MONTH(runtable.time) = 3 THEN 1 else NULL end) as 'Mar',
    COUNT(CASE WHEN MONTH(runtable.time) = 4 THEN 1 else NULL end) as 'Apr',
    COUNT(CASE WHEN MONTH(runtable.time) = 5 THEN 1 else NULL end) as 'May',
    COUNT(CASE WHEN MONTH(runtable.time) = 6 THEN 1 else NULL end) as 'Jun',
    COUNT(CASE WHEN MONTH(runtable.time) = 7 THEN 1 else NULL end) as 'Jul',
    COUNT(CASE WHEN MONTH(runtable.time) = 8 THEN 1 else NULL end) as 'Aug',
    COUNT(CASE WHEN MONTH(runtable.time) = 9 THEN 1 else NULL end) as 'Sep',
    COUNT(CASE WHEN MONTH(runtable.time) = 10 THEN 1 else NULL end) as 'Oct',
    COUNT(CASE WHEN MONTH(runtable.time) = 11 THEN 1 else NULL end) as 'Nov',
    COUNT(CASE WHEN MONTH(runtable.time) = 12 THEN 1 else NULL end) as 'Dec',
    COUNT(pareto.failure) as 'Total year'
FROM 
    runtable
    JOIN pareto 
        ON pareto.run_id = runtable.id
WHERE
    runtable.time BETWEEN '2016-01-01 00:00:00' AND '2016-12-13 23:59:59'     
    AND runtable.operation IN ('d','hr')
GROUP BY 
    runtable.operation, pareto.failure
;


absolute service time: 0,31 sec