SQL Queries - CAST Central Base - Queries on Objects - How to get the number of object type per subset per module and per technology in the application for all snapshots

SELECT ds.snapshot_name, 
       app.object_full_name         AS application_full_name, 
       module.object_full_name      AS module_full_name, 
       tech_module.object_full_name AS subset_name, 
       typ.typnam                   AS object_type, 
       Count(art.object_id) 
FROM   dss_objects art 
       INNER JOIN dss_object_info snap_art 
               ON snap_art.object_id = art.object_id 
       INNER JOIN dss_link_info l2 
               ON l2.next_object_id = art.object_id 
                  AND l2.link_type_id = 3 
                  AND l2.snapshot_id = snap_art.snapshot_id 
       INNER JOIN dss_link_info l1 
               ON l1.next_object_id = l2.previous_object_id 
                  AND l1.link_type_id = 1 
                  AND l1.snapshot_id = l2.snapshot_id 
       INNER JOIN dss_link_info l0 
               ON l0.next_object_id = l1.previous_object_id 
                  AND l0.link_type_id = 1 
                  AND l0.snapshot_id = l1.snapshot_id 
       INNER JOIN dss_objects module 
               ON module.object_id = l1.previous_object_id 
                  AND module.object_type_id = 20000 
       /* subsets*/ 
       JOIN dss_objects tech_module 
         ON tech_module.object_id = l2.previous_object_id 
       /* functional module */ 
       INNER JOIN dss_object_info snap_module 
               ON snap_module.object_id = module.object_id 
                  AND snap_module.snapshot_id = snap_art.snapshot_id 
       INNER JOIN dss_objects app 
               ON app.object_id = l0.previous_object_id 
                  AND app.object_type_id = -102 
       /* application */ 
       INNER JOIN dss_object_info snap_app 
               ON snap_app.object_id = app.object_id 
                  AND snap_app.snapshot_id = snap_art.snapshot_id 
       INNER JOIN typ 
               ON typ.idtyp = art.object_type_id 
       JOIN dss_snapshots ds 
         ON ds.snapshot_id = snap_app.snapshot_id 
GROUP  BY ds.snapshot_name, 
          app.object_full_name, 
          module.object_full_name, 
          tech_module.object_full_name, 
          typ.typnam 
ORDER  BY ds.snapshot_name, 
          app.object_full_name, 
          module.object_full_name, 
          tech_module.object_full_name 

Enter the SQL query

Enter the SQL query