Hi All Query objects can also perform calculations on data, such as finding the sum or average of all values in a column of the dataset. Business Central query objects enable you to retrieve records from one or more tables and then combine the data into rows and columns in a single dataset.

https://divyeshchittenavbc.wordpress.com/2020/03/17/blog-series-part-1-customer-requirement-for-al-development/