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
;