SELECT

COUNT(p.id) AS statisticsCount,

c.dept,

c.type,

p.userId,

p.baiban

FROM

de_tbfw_order_schedulingperson p ,

de_tbfw_order_scheduling c

where

p.tbfwSchedulingId = c.id

and

date(c.paibanDate) BETWEEN '2014-07-1'

AND '2014-08-15'

AND

c.dept ='二组'

GROUP BY

p.userId,

c.dept,

c.type,

p.baiban