SELECT
    PF_CODE  AS CODE
    , TOTAL_VALUE  AS SALES_AMT
FROM
    CONVENIENCE 
WHERE
    SURVEY_YEAR = 2019 
    AND KIND_CODE LIKE '100' 
GROUP BY PF_CODE
ORDER BY
    SALES_AMT DESC
    , CODE ASC;