SELECT rede,
            emp,
            codmarca,
            rol,
            (CASE WHEN ac <= 50 THEN 'A' WHEN ac <= 80 THEN 'B' ELSE 'C' END) AS curva_rol
        FROM (SELECT rede,
                    emp,
                    codmarca,
                    SUM(rol) AS rol,
                    SUM(SUM(fr)) over (PARTITION BY rede ORDER BY rol DESC rows unbounded preceding) AS ac
                FROM (
                SELECT rede,
                        emp,
                        codmarca,
                        rol,
                        100*RATIO_TO_REPORT((CASE WHEN rol > 0 THEN rol END)) over (PARTITION BY rede) fr
                    FROM (SELECT 'REDE' AS rede,
                                a.emp ,
                                a.cod_marca AS codmarca,
                                ROUND(SUM(rol),2) AS rol
                            FROM vm_skvendaitem_master a
                            WHERE 1 = 1
                            AND TRUNC(a.data,'MM') >= '01/11/2021'
                            AND a.marca NOT IN ('MWM','MWM IESA','MWM OPCIONAL','EMERGENCIAL')

                            AND TRUNC(a.data) >= TO_DATE('01/01/2022') AND TRUNC(a.data) <= SYSDATE


                            GROUP BY a.emp, a.cod_marca)
            )
            GROUP BY rede, emp,codmarca, rol )
    ORDER BY emp,codmarca, ac ASC