select
    pf_code as "CODE"
    ,sum(total_value) as "SALES_AMT"
from
    convenience
where
    survey_year = 2019
    and kind_code = '100'
group by
    pf_code
order by
    "SALES_AMT" desc, "CODE"
;