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