Nested select statement in SQL Server

[Clippy]

Nested select statement in SQL Server

[Clippy]

You need to alias the subquery.

```
SELECT name FROM (SELECT name FROM agentinformation) a

```

or to be more explicit

```
SELECT a.name FROM (SELECT name FROM agentinformation) a

```