select workflowname,count(*) from workflow_requestbase wr 
left join  workflow_base wb   on wb.id = wr.workflowid
where  
wr.createdate BETWEEN '2023-12-01' and '2024-01-21'
AND wr.currentnodetype=3
and wb.SUBCOMPANYID = 207 
and  wb.isvalid=1 
and  wb.islockworkflow = 0 
and wb.workflowname not like '%无效%'
and wb.workflowname not like '%测试%'
and wb.workflowname not like '%巴黎%'
and wb.workflowname not like '%历史%'

group by wb.workflowname
limit 1000;