MindsDB supports standard SQL syntax, including the SQL aggregate functions.SQL aggregate functions perform calculations on a set of values and return a single result, making them useful for summarizing or analyzing data across multiple rows. Common aggregate functions include COUNT(), SUM(), AVG(), MIN(), and MAX(). These functions are used with GROUP BY to organize results by specific categories.
Copy
Ask AI
SELECT year, SUM(salary) AS annual_salaryFROM salariesGROUP BY year;