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
;