Use common aggregate functions

sql

SELECT
  COUNT(*) AS total_rows,
  SUM(amount) AS total_amount,
  AVG(amount) AS avg_amount,
  MIN(amount) AS min_amount,
  MAX(amount) AS max_amount
FROM payments;

Explanation

Most SQL engines support these core aggregate functions.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commands View fixes

Related commands

Same sheet · prioritizing Aggregation and Grouping

Count rows

Return total row count.

Open In sheetsqlsame section

Group by a column

Aggregate values per group.

Open In sheetsqlsame section

Group by multiple columns

Aggregate by more than one dimension.

Open In sheetsqlsame section

Filter groups with HAVING

Apply conditions after aggregation.

Open In sheetsqlsame section

Select all columns

Return all columns from a table.

Open In sheetsql

Filter with equality

Return rows matching an exact value.

Open In sheetsql