select
  PF_CODE CODE,
  TOTAL_VALUE SALES_AMT
from CONVENIENCE
where
  SURVEY_YEAR = 2019 and
  KIND_CODE = '100'
order by SALES_AMT desc, CODE
;