求sql group by 后二进制或运算

Question

如图所示，group by日期后，数值结果为1111，在线等

Answer 1

 select concat(substring('110',1,1)|substring('1011',1,1),
         substring('110',2,1)|substring('1011',2,1),
        substring('110',3,1)|substring('1011',3,1),
        substring('110',4,1)|substring('1011',4,1));