select left(A.monitorby,4),count(A.monitorby) as dd，max(b.name) as name
from TM_TODOLIST A join usergroup B on A.ASSIGNTO = B.ID group by A.monitorby;
select left(A.monitorby,4),count(A.monitorby) as dd,max(b.name) as name
from TM_TODOLIST A join usergroup B on A.ASSIGNTO = B.ID group by A.monitorby;
select left(A.monitorby,4),count(A.monitorby) as dd,
max(b.name) as name --对name做一个筛选，找其中的一个。
from TM_TODOLIST A join usergroup B
on A.ASSIGNTO = B.ID group by A.monitorby
group by left(A.monitorby,4)
