SELECT
    PF_CODE  AS CODE
    , 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;