--SELECT
--    ,販売額合計 AS TTL_SAL
--    ,販売額比率 AS PER_SAL
--    ,累計販売額比率 AS CUM_SAL
--    ,1店舗当たりの平均販売額 AS AVG_SAL



SELECT 
    RANK() OVER (
    	ORDER BY SALE,STORE,PF_CODE
    ) AS NO
    ,PF_CODE

FROM
    (
        SELECT
            PF_CODE
            ,MAX(CASE WHEN KIND_CODE = '100' THEN TOTAL_VALUE ELSE NULL END) AS SALE
            ,MAX(CASE WHEN KIND_CODE = '150' THEN TOTAL_VALUE ELSE NULL END) AS STORE
        FROM
            CONVENIENCE
        WHERE
            SURVEY_YEAR = '2019'
        GROUP BY
            PF_CODE
    )