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
;