select PF_CODE AS CODE,
TOTAL_VALUE AS SALES_AMT
from CONVENIENCE
where KIND_CODE == "100"
order by SALES_AMT DESC, CODE ASC;