SELECT
co.pf_code AS CODE
,co.total_value AS SALES_AMT
FROM CONVENIENCE co
WHERE co.survey_year = 2019
AND co.kind_code = '100'
ORDER BY total_value DESC
,SALES_AMT DESC
,CODE ASC
;