为什么我不能使用SELECT ... FOR UPDATE with aggregate functions？

I have an application where I find a sum() of a database column for a set of records and later use that sum in a separate query, similar to the following (made up tables, but the idea is the same):I have an application where I find a sum() of a