create table STAT_TEST (

  id int not null AUTO_INCREMENT,

  active bool not null,

  data1 bigint,

  data2 bigint,

  data3 bigint,

  primary key (id)

);

insert into STAT_TEST (active,data1,data2,data3)

values(1,null,100,200);

MariaDB [test]> select

    ->   case when active then sum(data1) end as C_1,

    ->   sum(data2) as C_2,

    ->   sum(data3) as C_3

    -> from STAT_TEST;

+------+------+------+

| C_1  | C_2  | C_3  |

+------+------+------+

|    0 | NULL |  100 |

+------+------+------+

1 row in set (0.00 sec)

MariaDB [test]> select

    ->   if(active, sum(data1), 5) as C_1,

    ->   sum(data2) as C_2,

    ->   sum(data3) as C_3

    -> from STAT_TEST;

+------+------+------+

| C_1  | C_2  | C_3  |

+------+------+------+

|    0 | NULL |  100 |

+------+------+------+

1 row in set (0.00 sec)