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;