分享Mysql按条件汇总并指定成字段名

源表单据

+----+----------+-------+
| id | username | score |
+----+----------+-------+
|  1 | user1    |    50 |
|  2 | user2    |    98 |
|  3 | user3    |    67 |
|  4 | user4    |    89 |
|  5 | user5    |    34 |
|  6 | user6    |   100 |
|  7 | user7    |    65 |
|  8 | user8    |    87 |
|  9 | user9    |    97 |
| 10 | user10   |    55 |
+----+----------+-------+

汇总要求

+------+--------+
| 及格 | 不及格 |
+------+--------+
|    7 |      3 |
+------+--------+

两种sql方式实现

select sum(if(score>=60,1,0)) 及格,sum(if(score<60,1,0)) 不及格  from user;

select(select count(*) from user where score>=60) 及格,(select count(*) from user where score<60) 不及格;