SELECT
PF_CODE AS CODE,
TOTAL_VALUE AS SALES_AMT

FROM
CONVENIENCE

WHERE SURVEY_YEAR = 2019 AND KIND_CODE = 100
ORDER BY 2 DESC,1;