Test, MySQL - rextester

Language: Layout:

--- Set up
drop table `table`;

CREATE TABLE `table`
(
    `type` int,
    `status` bool,
    `status_cancel` bool,
    `date_finish` datetime,
    `result` integer
);

INSERT INTO `table` (type, `status`,status_cancel,date_finish,result) VALUES (1,1,0,NOW(),0);
INSERT INTO `table` (type, `status`,status_cancel,date_finish,result) VALUES (0,1,0,NOW(),0);
INSERT INTO `table` (type, `status`,status_cancel,date_finish,result) VALUES (1,0,0,null,0);
INSERT INTO `table` (type, `status`,status_cancel,date_finish,result) VALUES (1,0,0,NOW(),5);
INSERT INTO `table` (type, `status`,status_cancel,date_finish,result) VALUES (1,0,0,NOW(),0);
INSERT INTO `table` (type, `status`,status_cancel,date_finish,result) VALUES (1,1,0,NOW(),0);
INSERT INTO `table` (type, `status`,status_cancel,date_finish,result) VALUES (1,1,0,'2014-08-13',0);
INSERT INTO `table` (type, `status`,status_cancel,date_finish,result) VALUES (1,1,0,'2014-08-13',0);
INSERT INTO `table` (type, `status`,status_cancel,date_finish,result) VALUES (1,1,0,'2014-08-13',0);

-- Actual code
SELECT	DATE(date_finish) as `date`, count(*) as 'Total', 
		SUM(CASE WHEN `status` = 0 AND `status_cancel` = 0 THEN 1 ELSE 0 END) as 'Open',
		SUM(CASE WHEN `status_cancel` = 1 THEN 1 ELSE 0 END) as 'Cancel',
		SUM(CASE WHEN `date_finish` is not null and `status_cancel` = 0 THEN 1 ELSE 0 END) as 'Finish',
		SUM(CASE WHEN `result` >= 0 AND `date_finish` is not null AND `status_cancel` = 0 THEN 1 ELSE 0 END) as 'Win',
		SUM(CASE WHEN `result` < 0 AND `date_finish` is not null AND `status_cancel` = 0 THEN 1 ELSE 0 END) as 'Loss'
from `table` 
WHERE `type` = 1 
group by DATE(date_finish)


absolute service time: 0,33 sec