select SUBCOMPANYNAME, count()
from workflow_base
 left join hrmsubcompany on hrmsubcompany.id = workflow_base.SUBCOMPANYID
where WORKFLOWTYPE NOT IN (1, 171, 89, 105, 223)
  and ISVALID = '1'
group by SUBCOMPANYNAME