SELECT
    PF_CODE AS CODE,
    SUM(TOTAL_VALUE) AS SALES_AMT
FROM
    CONVENIENCE
GROUP BY
    PF_CODE
ORDER BY
    SALES_AMT DESC,
    CODE ASC
;