计算SQL中的相关子查询

I'm having trouble getting my head around evaluating correlated subqueries. An example is using a correlated subquery in SELECT so that GROUP BY isn't needed:I'm having trouble getting my head around evalu