select displayName,tname,count(type) from fine_record_execute
where todate(time)>='${start} 00:00:00'
and todate(time)<='${end} 23:59:59'
and type<=3
${if(len(tname)==0,"","and tname like '"+tname+"%'")}
GROUP BY displayName,tname
order by displayName desc