Implementation of this functionality, please the great god

CodePudding user response:

Select day, count (status=0) c0, count (status=1) c from t_table group by day