组合sql语句 ，在一张表中查询调用记录 并把成功记录查出来 ，显示在一张表

组合sql语句 ，在一张表中查询调用记录 并把成功记录查出来 ，显示在一张表

select *,
正常签收+延迟签收+未签收 as 合计
from (
select 所属类型,所属片区,
sum(case when 签收类型 = ‘正常签收’ then 1 else 0 end) as 正常签收,
sum(case when 签收类型 = ‘延迟签收’ then 1 else 0 end) as 延迟签收,
sum(case when 签收类型 = ‘未签收’ then 1 else 0 end) as 未签收
from 一派签收率数据源
where (日期 BETWEEN ‘2015-07-08’ AND ‘2015-07-09’)
group by 所属类型,所属片区
) as a
order by 所属片区 asc;

SELECT
app_id,
x_sys_record.service_id as handler_id,
date(x_sys_record.create_time) as dates,
count(x_sys_record.service_id) as counts,
sum(case when x_sys_record.biz_code =‘200’ then 1 else 0 end) as success_count
FROM
x_sys_record


and app_id=#{appId}


and service_id=#{handlerId}


GROUP BY date(x_sys_record.create_time) ,x_sys_record.service_id