SQL Queries - Common SQL Queries - Queries on Modules - How to get the count of objects in the modules based on its type

SELECT   cpm.OBJECT_ID  ,
         cpm.OBJECT_NAME,
         s.SUBSET_ID    ,
         s.SUBSET_NAME  ,
         t.IdTyp        ,
         t.typNam       ,
         t.TypDsc       ,
         COUNT(pso.OBJECT_ID)
FROM     [mngt].cms_portf_module cpm
         JOIN [local].PMC_SUBSETS s
         ON       s.SUBSET_NAME = 'CMS_MOD__'
                           || cpm.OBJECT_ID
                           || '_Preparation2'
         JOIN [local].PMC_SUBSET_OBJECTS pso
         ON       pso.SUBSET_ID = s.SUBSET_ID
         JOIN [local].Keys k
         ON       k.IdKey = pso.OBJECT_ID
         JOIN [local].Typ t
         ON       t.IdTyp = k.ObjTyp
GROUP BY cpm.OBJECT_ID  ,
         cpm.OBJECT_NAME,
         s.SUBSET_ID    ,
         s.SUBSET_NAME  ,
         t.IdTyp        ,
         t.typNam       ,
         t.TypDsc
ORDER BY cpm.OBJECT_ID  ,
         cpm.OBJECT_NAME,
         s.SUBSET_ID    ,
         s.SUBSET_NAME  ,
         t.IdTyp        ,
         t.typNam       ,
         t.TypDsc