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 | |
) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment