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;