sql | how to avoid multiple identical subqueries in the SELECT clause

continuing from sql | how NOT to avoid multiple identical subqueries in the SELECT clause these won't work if your db is older than 12c. if it is lower, i guess the how NOT to is the how to, not an expert don't quote me on that. and no i don't want ...