SELECT
    PF_CODE AS CODE
    , TOTAL_VALUE AS SALES_AMT
FROM
    CONVENIENCE
WHERE
    SURVEY_YEAR = 2019
    AND
    KIND_CODE = 100 -- 販売額
ORDER BY
    SALES_AMT DESC
    , CODE ASC
;