Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE T
(
  GP_ID          INTEGER,
  MBR_GR_ID      INTEGER,
  BEZIRK_ID      INTEGER,
  GEBIET_ID      INTEGER,
  MBR_ID         INTEGER GENERATED BY DEFAULT ON NULL AS IDENTITY ( START WITH 92541 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE CACHE 20 NOORDER NOKEEP NOSCALE) NOT NULL,
  MONTH          INTEGER,
  YEAR           INTEGER,
  SUMME          INTEGER,
  GP_GR_ID       INTEGER,
  DELETED        INTEGER,
  IS_SUM         INTEGER,
  MBR_PRODGR     VARCHAR2(32 BYTE),
  MBR_PRODGR_ID  NUMBER
)
 insert all into t
 Values
   (NULL, 1, NULL, NULL, 60884, 
    5, 2023, 3, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60885, 
    5, 2023, 1, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60886, 
    5, 2023, 1, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60887, 
    5, 2023, 1, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60888, 
    5, 2023, 2, 5, 0, 
    NULL, 'Kompaktbrief', 3)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60889, 
    5, 2023, 2, 5, 0, 
    NULL, 'Maxibrief', 5)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60890, 
    5, 2023, 2, 5, 0, 
    NULL, 'Maxibrief', 5)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60891, 
    5, 2023, 2, 5, 0, 
    NULL, 'Maxibrief', 5)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60892, 
    5, 2023, 1, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60893, 
    5, 2023, 1, 5, 0, 
    NULL, 'Großbrief', 4)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60894, 
    5, 2023, 1, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60895, 
    5, 2023, 2, 5, 0, 
    NULL, 'Maxibrief', 5)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 2, NULL, NULL, 60896, 
    5, 2023, 2, 5, 0, 
    NULL, 'Info Standard', 7)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 2, NULL, NULL, 60897, 
    5, 2023, 2, 5, 0, 
    NULL, 'Info Standard', 7)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 2, NULL, NULL, 60898, 
    5, 2023, 2, 5, 0, 
    NULL, 'Info Standard', 7)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 2, NULL, NULL, 60899, 
    5, 2023, 2, 5, 0, 
    NULL, 'Info Standard', 7)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 2, NULL, NULL, 60900, 
    5, 2023, 2, 5, 0, 
    NULL, 'Info Standard', 7)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 2, NULL, NULL, 60901, 
    5, 2023, 2, 5, 0, 
    NULL, 'Info Groß', 9)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60902, 
    5, 2023, 1, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60903, 
    5, 2023, 1, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60904, 
    5, 2023, 1, 5, 0, 
    NULL, 'Großbrief', 4)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60905, 
    5, 2023, 2, 5, 0, 
    NULL, 'Maxibrief', 5)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60906, 
    5, 2023, 2, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60907, 
    5, 2023, 1, 5, 0, 
    NULL, 'Großbrief', 4)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60908, 
    5, 2023, 1, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60909, 
    5, 2023, 2, 5, 0, 
    NULL, 'Maxibrief', 5)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 3, NULL, NULL, 60910, 
    5, 2023, 1, 5, 0, 
    NULL, 'Bücher- Warensendungen', 12)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60911, 
    5, 2023, 1, 5, 0, 
    NULL, 'Großbrief', 4)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60912, 
    5, 2023, 2, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60913, 
    5, 2023, 1, 5, 0, 
    NULL, 'Großbrief', 4)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60914, 
    5, 2023, 1, 5, 0, 
    NULL, 'Großbrief', 4)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60915, 
    5, 2023, 1, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60916, 
    5, 2023, 1, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60917, 
    5, 2023, 1, 5, 0, 
    NULL, 'Großbrief', 4)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60918, 
    5, 2023, 2, 5, 0, 
    NULL, 'Kompaktbrief', 3)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60919, 
    5, 2023, 2, 5, 0, 
    NULL, 'Maxibrief', 5)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60920, 
    5, 2023, 2, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60921, 
    5, 2023, 2, 5, 0, 
    NULL, 'Maxibrief', 5)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60922, 
    5, 2023, 2, 5, 0, 
    NULL, 'Kompaktbrief', 3)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 3, NULL, NULL, 60923, 
    5, 2023, 1, 5, 0, 
    NULL, 'Bücher- Warensendungen', 12)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60924, 
    5, 2023, 1, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 3, NULL, NULL, 60925, 
    5, 2023, 1, 5, 0, 
    NULL, 'Bücher- Warensendungen', 12)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60926, 
    5, 2023, 1, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60927, 
    5, 2023, 2, 5, 0, 
    NULL, 'Kompaktbrief', 3)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60928, 
    5, 2023, 1, 5, 0, 
    NULL, 'Großbrief', 4)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60929, 
    5, 2023, 1, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60930, 
    5, 2023, 1, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60931, 
    5, 2023, 1, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60932, 
    5, 2023, 1, 5, 0, 
    NULL, 'Großbrief', 4)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60933, 
    5, 2023, 4, 5, 0, 
    NULL, 'Maxibrief', 5)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60934, 
    5, 2023, 2, 5, 0, 
    NULL, 'Kompaktbrief', 3)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60935, 
    5, 2023, 1, 5, 0, 
    NULL, 'Großbrief', 4)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 3, NULL, NULL, 60936, 
    5, 2023, 1, 5, 0, 
    NULL, 'Bücher- Warensendungen', 12)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60937, 
    5, 2023, 1, 5, 0, 
    NULL, 'Standardbrief', 2)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60938, 
    5, 2023, 6, 5, 0, 
    NULL, 'Maxibrief', 5)
 into t
   (GP_ID, MBR_GR_ID, BEZIRK_ID, GEBIET_ID, MBR_ID, 
    MONTH, YEAR, SUMME, GP_GR_ID, DELETED, 
    IS_SUM, MBR_PRODGR, MBR_PRODGR_ID)
 Values
   (NULL, 1, NULL, NULL, 60939, 
    5, 2023, 2, 5, 0, 
    NULL, 'Standardbrief', 2)
select 1 from dual
56 rows affected

    SELECT --GROUPING_ID(mbr_prodgr, mbr_prodgr_id),grouping(mbr_prodgr),grouping (mbr_prodgr_id),
    year,       
    gp_gr_id,
    --mbr_gr_id,
    --GROUPING_ID(mbr_gr_id) AS mbr_gr_id_grouping,
    gp_id,bezirk_id,
    --GROUPING_ID(mbr_prodgr, mbr_prodgr_id) AS mbr_prodgr_grouping,
    CASE
        WHEN GROUPING_ID(mbr_prodgr) = 1 --and mbr_prodgr not in ('PZA') 
        THEN 'Sum'
        ELSE mbr_prodgr 
    END AS mbr_prodgr,
    COALESCE(SUM(CASE WHEN month = 4 THEN summe END), 0) AS apr,
    COALESCE(SUM(CASE WHEN month = 5 THEN summe END), 0) AS mai,
    COALESCE(SUM(CASE WHEN month = 6 THEN summe END), 0) AS juni,
    sum(summe) summe_jahr 
FROM t 
WHERE deleted =0 
      AND mbr_prodgr_id IS NOT NULL 
GROUP BY 
    year, gp_gr_id, mbr_gr_id, gp_id, bezirk_id,ROLLUP(mbr_prodgr, mbr_prodgr_id)
HAVING (GROUPING_ID(mbr_prodgr, mbr_prodgr_id) = 0 OR GROUPING_ID(mbr_prodgr, mbr_prodgr_id) = 3)
ORDER BY
    year, gp_gr_id, mbr_gr_id, gp_id, bezirk_id,mbr_prodgr_id


YEAR
GP_GR_ID
GP_ID
BEZIRK_ID
MBR_PRODGR
APR
MAI
JUNI
SUMME_JAHR


2023
5
null
null
Standardbrief
0
27
0
27

2023
5
null
null
Kompaktbrief
0
10
0
10

2023
5
null
null
Großbrief
0
10
0
10

2023
5
null
null
Maxibrief
0
26
0
26

2023
5
null
null
Sum
0
73
0
73

2023
5
null
null
Info Standard
0
10
0
10

2023
5
null
null
Info Groß
0
2
0
2

2023
5
null
null
Sum
0
12
0
12

2023
5
null
null
Bücher- Warensendungen
0
4
0
4

2023
5
null
null
Sum
0
4
0
4
YEAR	GP_GR_ID	GP_ID	BEZIRK_ID	MBR_PRODGR	MAI	SUMME_JAHR
2023	5	null	null	Standardbrief	27	27
2023	5	null	null	Kompaktbrief	10	10
2023	5	null	null	Großbrief	10	10
2023	5	null	null	Maxibrief	26	26
2023	5	null	null	Sum	73	73
2023	5	null	null	Info Standard	10	10
2023	5	null	null	Info Groß	2	2
2023	5	null	null	Sum	12	12
2023	5	null	null	Bücher- Warensendungen	4	4
2023	5	null	null	Sum	4	4