要sql语句？

--设开始时间变量,开始时间begindate,结束时间enddate

--工作日报评分从A表中取值，统计搜索时间内，销售的工作报告记录总条数

select name,count(1) as '工作日报评分' from A  where date between {begindate} and {enddate} group by name 

--客户拜访评分从A表中取值，统计搜索时间内，销售的工作报告类型为客户拜访记录的总条数

select name,count(1) as '客户拜访评分' from A  where date between {begindate} and {enddate}  and style = '客户拜访' group by name 

--工作周报评分从B表中取值，统计搜索时间内，销售扣分类型为工作周报的的扣分值之和

select name,sum(jiner)as '工作周报的的扣分值之和' from B where date between {begindate} and {enddate} and style = '工作周报' group by name 

--活动参与评分从B表中取值，统计搜索时间内，销售扣分类型为参加活动的扣分值之和

select name,sum(jiner) as '参加活动的扣分值之和' from B where date between {begindate} and {enddate} and style = '参加活动' group by name 

--新客户开发评分从C表中取值，统计搜索时间内，销售新增客户数之和

select name,count(khname) as '销售新增客户数之和' from C where date between {begindate} and {enddate} group by name 

有什么不懂的就私聊qq 425202395 ，这种表写的多了

select 

a.reportname,

a.工作日报数据,

b.客户拜访数据,

c.工作周报评分,

d.活动评分,

e.客户开发数量

from

/*工作日报*/

(select 

reportname,

count(report name) as 工作日报数据 

 from uf_work report 

where reportdate>='${ksrq}'

and reportdate<='${jsrq}'

group by reportname) a 

/*客户拜访*/

left join(

select 

reportname,

count(report name) as 客户拜访数据 

from uf_work report 

where reportstyle='0'

and reportdate>='${ksrq}'

and reportdate<='${jsrq}'

group by reportname) b  on a.reportname=b.reportname 

/*工作周报评分*/

left join(

select 

pfname,

sum(pfshuzi) as 工作周报评分 

from uf_xszdpf 

where pfdate>='${ksrq}'

and pfdate<='${jsrq}'

and pfstyle='0' group by pfname) c on a.reportname=c.pfname

 /*活动评分*/

left join(

select pfname,

sum(pfshuzi) as 活动评分 

from uf_xszdpf 

where pfdate>='${ksrq}'

and pfdate<='${jsrq}'

and pfstyle='1'

group by pfname) d on a.reportname=d.pfname 

/*客户开发数*/

left join(

select cjr,

count(cjr) as 客户开发数量 

from uf_khgl

where cjr>='${ksrq}'

and cjr='${jsrq}'

group by cjr) e on a.reportname=e.cjr