SELECT
    PF_CODE AS CODE,
    SUM(TOTAL_VALUE) AS SALES_AMT
FROM
    CONVENIENCE
WHERE
    SURVEY_YEAR = 2019
    AND KIND_CODE = '100'
GROUP BY
    PF_CODE
ORDER BY
    SALES_AMT DESC,
    CODE ASC
;