SELECT
    PF_CODE AS CODE,
    TOTAL_VALUE AS SALES_AMT

FROM CONVENIENCE

WHERE SURVEY_YEAR = 2019
    AND KIND_CODE = '100'

ORDER BY
    TOTAL_VALUE DESC,
    PF_CODE ASC;