cte_f.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
),
avg_sales_CTE 
as (

	SELECT AVG(JML_ORDER) AS rata_order
	from sales_cte

)
select * 
FROM Sales_CTE 
where jml_order > (select rata_order from avg_sales_CTE);