On Tue, Jan 15, 2019 at 9:52 AM Alexander Farber <alexander.far...@gmail.com> wrote: >> So calculate the average somewhere else, put the result in a column, >> and then reference that column in the SET clause. >> > > do you suggest to add a second CTE?
That would qualify as "somewhere else" - as would a simple subquery in FROM. David J.
