SELECT a.案件下发时间,a.案件下发数量,b.案件计费数量 from 
(select count(1) as '案件下发数量',date_format(create_time,'%Y-%m-%d') as '案件下发时间' from prpm_case_info 
GROUP BY  date_format(create_time,'%Y-%m-%d')
 ) a
LEFT JOIN 
-- 当天视频案件计费量
(select count(1) as '案件计费数量',date_format(create_time,'%Y-%m-%d') as '案件计费时间' from prpm_billing_info where 
billing_type in (3,4)  GROUP BY  date_format(create_time,'%Y-%m-%d'))
b on a.案件下发时间=b.案件计费时间
;
