The following pertains to how different versions Microsoft SQL Server may not be the same with regards to what aggregation types that they support. According to feedback during the time of this article in 2021, the following aggregation types are Enterprise Edition only.
- AverageOfChildren
- FirstChild
- ByAccount
- None
- LastChild
- LastNonEmpty
- FirstNonEmpty
A deploy-time error will be generated when used on other editions than Enterprise or Developer.