删除多次使用的select语句的子查询以优化性能

I have a following query, this query uses a subquery in the select clause multiple times asI have a following query, this query uses a sub