怎么统计这些数据中0与1个数

Question

select

DIAOCJG1, DIAOCJG2, DIAOCJG3, DIAOCJG4, DIAOCJG5, DIAOCJG6, DIAOCJG7, DIAOCJG8, DIAOCJG9, DIAOCJG10, DIAOCJG11, DIAOCJG12, DIAOCJG13, DIAOCJG14, DIAOCJG15, DIAOCJG16, DIAOCJG17, DIAOCJG18, DIAOCJG19, DIAOCJG20
from table1

Answer 1

select count(*), diaocjg1 from 表名 group by diaocjg1