cte_g.sql

use AdventureWorks2012
go

select * from 
(
	SELECT SalesPersonID, COUNT(*) as JML_ORDER
    FROM Sales.SalesOrderHeader
    WHERE SalesPersonID IS NOT NULL
    GROUP BY SalesPersonID
) a
where jml_order > (

	SELECT AVG(JML_ORDER) AS rata_order
	from (
		SELECT SalesPersonID, COUNT(*) as JML_ORDER
		FROM Sales.SalesOrderHeader
		WHERE SalesPersonID IS NOT NULL
		GROUP BY SalesPersonID
	) b

)