总量
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
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')
select
(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')) as 总量,
(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) as 质检数量,
(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) as A级数量,
(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) as B级数量,
(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)as C级数量
from dual
不知道是不是这个意思
类似这样的,
select now() as date, (select count(1) from t where cola > 0) as vala, (select count(1) from t where colb > 0) as valb;