WITH Total AS
(
    select
         SURVEY_YEAR
        ,PF_CODE
        ,TOTAL_VALUE AS TOTAL
    FROM
        CONVENIENCE
    WHERE
        KIND_CODE = '100'
)
, Stores AS
(
    select
         SURVEY_YEAR
        ,PF_CODE
        ,TOTAL_VALUE AS Stores
    FROM
        CONVENIENCE
    WHERE
        KIND_CODE = '100'
)
, Groups_2019 AS
(
    SELECT
         PF_CODE
        ,total_2019
        ,stores_2019
        ,ROW_NUMBER () OVER (order by total_2019 desc, stores_2019 asc, PF_CODE asc)
    FROM 
        (
        select
             SUM(T.TOTAL) AS total_2019
            ,SUM(S.Stores) AS stores_2019
            ,T.PF_CODE
        from
            Total T
        INNER JOIN
            Stores S
        ON 
            T.PF_CODE = S.PF_CODE
        WHERE 
            T.SURVEY_YEAR = 2019
        GROUP BY    
            T.PF_CODE
        )
)

select * from Groups_2019