Common Table Expression
AS keywords in newline
gFmtOpt.CTE_NewlineBeforeAs
boolean
default: true
Indent size of subquery
gFmtOpt.CTE_QueryIndentSize
integer
default: 0
SQL before beautify
WITH DirReps (Manager, DirectReports) AS
(
SELECT ManagerID, COUNT(*) AS DirectReports
FROM HumanResources.Employee
GROUP BY ManagerID
)
SELECT AVG(DirectReports) AS [Average Number of Direct Reports]
FROM DirReps
WHERE DirectReports>= 2 ;
GO
SQL after beautify
WITH dirreps ( manager, directreports )
AS
(
SELECT managerid,
Count ( * ) AS directreports
FROM humanresources.employee
GROUP BY managerid
)
SELECT Avg ( directreports ) AS [average number of direct reports]
FROM dirreps
WHERE directreports >= 2;
GO