SELECT PF_CODE AS CODE
,TOTAL_VALUE AS SALES_AMT
FROM CONVENIENCE
WHERE 1=1
AND SURVEY_YEAR=2019
AND KIND_CODE='100'
ORDER BY SALES_AMT desc,
CODE asc;