mysql 列转行之后，分别计数

Question

表名字是：test_tb_grade
脚本：
INSERT INTO test_tb_grade(id, USER_NAME, REQUEST_DATE, CODE) VALUES (1, '张三', '2017-02-01', '成功');
INSERT INTO test_tb_grade(id, USER_NAME, REQUEST_DATE, CODE) VALUES (2, '张三', '2017-02-01', '成功');
INSERT INTO test_tb_grade(id, USER_NAME, REQUEST_DATE, CODE) VALUES (3, '张三', '2017-01-01', '失败');
INSERT INTO test_tb_grade(id, USER_NAME, REQUEST_DATE, CODE) VALUES (4, '李四', '2017-01-01', '成功');
INSERT INTO test_tb_grade(id, USER_NAME, REQUEST_DATE, CODE) VALUES (5, '李四', '2017-03-01', '失败');
INSERT INTO test_tb_grade(id, USER_NAME, REQUEST_DATE, CODE) VALUES (6, '李四', '2017-02-01', '成功');
INSERT INTO test_tb_grade(id, USER_NAME, REQUEST_DATE, CODE) VALUES (7, '王五', '2017-01-01', '成功');
INSERT INTO test_tb_grade(id, USER_NAME, REQUEST_DATE, CODE) VALUES (8, '王五', '2017-03-01', '失败');
INSERT INTO test_tb_grade(id, USER_NAME, REQUEST_DATE, CODE) VALUES (9, '王五', '2017-03-01', '失败');
INSERT INTO test_tb_grade(id, USER_NAME, REQUEST_DATE, CODE) VALUES (10, '张三', '2017-02-01', '成功');
INSERT INTO test_tb_grade(id, USER_NAME, REQUEST_DATE, CODE) VALUES (11, '张三', '2017-02-01', '失败');
INSERT INTO test_tb_grade(id, USER_NAME, REQUEST_DATE, CODE) VALUES (12, '张三', '2017-01-01', '无效');
INSERT INTO test_tb_grade(id, USER_NAME, REQUEST_DATE, CODE) VALUES (13, '李四', '2017-01-01', '无效');
INSERT INTO test_tb_grade(id, USER_NAME, REQUEST_DATE, CODE) VALUES (14, '李四', '2017-03-01', '无效');
INSERT INTO test_tb_grade(id, USER_NAME, REQUEST_DATE, CODE) VALUES (15, '李四', '2017-01-01', '成功');
INSERT INTO test_tb_grade(id, USER_NAME, REQUEST_DATE, CODE) VALUES (16, '李四', '2017-03-01', '成功');
INSERT INTO test_tb_grade(id, USER_NAME, REQUEST_DATE, CODE) VALUES (17, '王五', '2017-03-01', '无效');

求得结果如下：

请问sql 可以实现吗

Answer 1

已实现结果！