我想要将以下的sql语句合并,使查询出的记录包含这些列

Question

总量
SELECT COUNT(1) TOTAL from T_CHAT_RECORDS TCR WHERE TCR.OPERATOR_PK='8a8a8ef464d53a670164e8e3568a0001' AND TCR.REQUEST_TIME>=TO_DATE('2018-12-05 00:00:00', 'yyyy-MM-dd HH24:mi:ss') AND TCR.REQUEST_TIME<=TO_DATE('2018-12-07 23:59:59', 'yyyy-MM-dd HH24:mi:ss')
质检数量
SELECT COUNT(1) CHECKED from T_CHAT_RECORDS TCR WHERE TCR.OPERATOR_PK='8a8a8ef464d53a670164e8e3568a0001' AND TCR.REQUEST_TIME>=TO_DATE('2018-12-05 00:00:00', 'yyyy-MM-dd HH24:mi:ss') AND TCR.REQUEST_TIME<=TO_DATE('2018-12-07 23:59:59', 'yyyy-MM-dd HH24:mi:ss') AND TCR.SCORE>0
A级数量
SELECT COUNT(1) AGRADE from T_CHAT_RECORDS TCR WHERE TCR.OPERATOR_PK='8a8a8ef464d53a670164e8e3568a0001' AND TCR.REQUEST_TIME>=TO_DATE('2018-12-05 00:00:00', 'yyyy-MM-dd HH24:mi:ss') AND TCR.REQUEST_TIME<=TO_DATE('2018-12-07 23:59:59', 'yyyy-MM-dd HH24:mi:ss') AND TCR.SCORE>=80 AND TCR.SCORE<=100
B级数量
SELECT COUNT(1) BGRADE from T_CHAT_RECORDS TCR WHERE TCR.OPERATOR_PK='8a8a8ef464d53a670164e8e3568a0001' AND TCR.REQUEST_TIME>=TO_DATE('2018-12-05 00:00:00', 'yyyy-MM-dd HH24:mi:ss') AND TCR.REQUEST_TIME<=TO_DATE('2018-12-07 23:59:59', 'yyyy-MM-dd HH24:mi:ss') AND TCR.SCORE>=60 AND TCR.SCORE C级数量
SELECT COUNT(1) CGRADE from T_CHAT_RECORDS TCR WHERE TCR.OPERATOR_PK='8a8a8ef464d53a670164e8e3568a0001' AND TCR.REQUEST_TIME>=TO_DATE('2018-12-05 00:00:00', 'yyyy-MM-dd HH24:mi:ss') AND TCR.REQUEST_TIME<=TO_DATE('2018-12-07 23:59:59', 'yyyy-MM-dd HH24:mi:ss') AND TCR.SCORE>0 AND TCR.SCORE<60

Answer 1

SELECT 
    COUNT(1) TOTAL, 
    COUNT(IF(TCR.SCORE > 0, 1, NULL)) CHECKED,
    COUNT(IF(TCR.SCORE>=80 AND TCR.SCORE<=100, 1, NULL)) AGRADE,
    COUNT(IF(TCR.SCORE>=60 AND TCR.SCORE<80, 1, NULL)) BGRADE,
    COUNT(IF(TCR.SCORE>0 AND TCR.SCORE<60, 1, NULL)) CGRADE
FROM
    T_CHAT_RECORDS TCR
WHERE
    TCR.OPERATOR_PK = '8a8a8ef464d53a670164e8e3568a0001'
    AND TCR.REQUEST_TIME BETWEEN TO_DATE('2018-12-05 00:00:00','yyyy-MM-dd HH24:mi:ss') AND TCR.REQUEST_TIME <= TO_DATE('2018-12-07 23:59:59','yyyy-MM-dd HH24:mi:ss')