Report question

Question: Nested select statement in SQL Server