SUM Function

Calculates the total sum of a numeric column.

AVG Function

Computes the average value of a numeric column.

MAX Function

Retrieves the maximum value from a column.

MIN Function

Retrieves the minimum value from a column.

COUNT Function

Counts the number of rows or non-NULL values in a column.

LIKE Operator

Used in a WHERE clause to search for a specified pattern in a column.

GROUP BY Clause

Groups rows that have the same values into summary rows.

ORDER BY Clause

Sorts the result set of a query in ascending or descending order.

HAVING Clause

Filters groups based on a specified condition.