新用户胖虎是女生(提问者)SELECT DISTINCT
-- A.time,
job_site_name AS 作业点,
queue AS 队列,
A.se_no AS 员工号,
B.se_name AS 催收员,
ROUND( wait_hour, 2 ) AS 等待时长,
ROUND( tong_hour, 2 ) AS 通话时长,
connect_none AS 未接通数量,
connect AS 接通数量,
ROUND( A.wait_hour + A.tong_hour, 2 ) AS 作业时长,
A.connect_none + A.connect AS 当日总拨打量
FROM
(
SELECT
DATE_FORMAT( time, '%Y-%m-%d' ) AS time,
job_site_name,
queue,
se_no,
SUM( wait_hour ) AS wait_hour,
SUM( tong_hour ) AS tong_hour,
SUM( connect_none ) AS connect_none,
SUM( connect ) AS connect
FROM
DY_PFBB_TSTL
WHERE
DATE (time) = '${days}'
AND queue IN ('A组特关', 'T1_01')
GROUP BY
job_site_name,
queue,
se_no,(
DATE_FORMAT( time, '%Y-%m-%d' ))
) A
LEFT JOIN DY_ZJTD_ZH B ON A.se_no = B.se_no
and
B.bank = '浦发银行';
这是通时通量sql查询
1min目标场景问卷
立即参与
