cte_d.sql

use AdventureWorks2012
go

WITH Sales_CTE
AS
(
    SELECT SalesPersonID, COUNT(*) as JML_ORDER
    FROM Sales.SalesOrderHeader
    WHERE SalesPersonID IS NOT NULL
    GROUP BY SalesPersonID
)
SELECT AVG(JML_ORDER) AS "Average Sales Per Person"
FROM Sales_CTE;