JBPM统计某流程提交人信息

select count(*),vi.stringvalue_ from jbpm_variableinstance vi where  vi.name_='proposer'
and vi.processinstance_ in (
          select pi.id_ from   jbpm_processinstance pi where pi.processdefinition_=(
                  select id_ from jbpm_processdefinition  where  version_=(
                        select max(version_) from jbpm_processdefinition where name_='流程名称')
                  )
          )
group by vi.stringvalue_