radityopw/cte_d.sql
Created Feb 29, 2016

Star 0
Fork 0

Raw

      
        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;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

You can’t perform that action at this time.