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;