WITH SAL_TBL AS 
(
    SELECT
        ((ROW_NUMBER() OVER w) + 2) / 3 AS NO, 
        A.PF_CODE AS PF_CODE,
        A.TOTAL_VALUE AS SAL,
        B.TOTAL_VALUE AS SHOP
    FROM 
    (SELECT * FROM CONVENIENCE WHERE KIND_CODE = '100' AND SURVEY_YEAR = '2019') AS A
    INNER JOIN
    (SELECT * FROM CONVENIENCE WHERE KIND_CODE = '150' AND SURVEY_YEAR = '2019') AS B
    ON A.PF_CODE = B.PF_CODE
    WINDOW w AS (ORDER BY A.TOTAL_VALUE DESC, B.TOTAL_VALUE ASC, A.PF_CODE ASC)
    ORDER BY NO
),
PF_SAL AS 
(
    SELECT 
        NO,
        SUM(SAL) AS TTL_SAL, 
        SUM(SAL) / SUM(SHOP) AS AVG_SAL 
    FROM SAL_TBL
    GROUP BY NO
)
SELECT
    NO,
    TTL_SAL,
    ROUND(100.0 * TTL_SAL / (SUM(TTL_SAL) OVER ()), 1) AS PER_SAL,
    ROUND(100.0 * SUM(TTL_SAL) OVER w / (SUM(TTL_SAL) OVER ()), 1) AS CUM_SAL,
    AVG_SAL
    FROM PF_SAL
    WINDOW w AS (
        ORDER BY NO
    )