WITH ...
SELECT `branch_brand`.`branch_code`,
       ANY_VALUE(`branch_brand`.`branch_name`),
       --                                  vvvvvvvvvv problem here
       SUM(`branch_brand`.`valuation`) AS `valuation`,
       -- doesn't matter how I reference `valuation`, it doesn't work
       `valuation` as `v2`,
       `valuation` * 1
FROM `branch_brand`
GROUP BY `branch_brand`.`branch_code`
--        vvvvvvvvv this works :/
ORDER BY `valuation` DESC

# Error
ERROR 1064 (HY000): Getting analyzing error at line 34, column 7. Detail message: '`branch_brand`.`valuation`' must be an aggregate expression or appear in GROUP BY clause.

Why can I reference an aggregated field in the SELECT?