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 ASC
,CODE DESC
;