Aggregating Data in SQL

 Aggregating Data in SQL

SQL provides various aggregate functions to perform calculations on groups of data. Here's an example:

vbnet

SELECT department, AVG(age) as avg_age, MAX(age) as max_age

FROM employees

GROUP BY department;

In this example, we're calculating the average and maximum age for each department using the AVG and MAX functions respectively. The GROUP BY clause is used to group the data by department.