Title - Aggregates Tags - sql
SQL queries can perform calculations on raw data to answer specific questions.
Calculations performed on multiple rows of a table are called aggregates.
Here are some of the aggregates you can use:
COUNT(): to count the number of rows
SUM(): to sum the values in a column
MAX()/MIN(): to get the largest/smallest value
AVG(): to get the average of the values in a column
ROUND(): to round the values in the column