mysql - MySQL 中是否可以有条件地计数和添加行标签？

Question

我有一个数据集

HAPPY
1
0
0
0
0
1
1

我想统计返回的 1 和 0

Status | Count
YES    | 3
NO     | 4

Answer 1

select if (HAPPY=1, 'YES', 'NO') as Status,
    count(HAPPY) as Count from Table1 group by HAPPY order by Status desc;