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
;