select
    pf_code as 'CODE',
    total_value as 'SALES_AMT'
from
    convenience
where
    survey_year == 2019
and
    kind_code == '100'
order by
    `SALES_AMT` desc,
    `CODE` asc;