lesson1Title

lesson2Title

lesson3Title

lesson4Title

lesson5Title

lesson6Title

lesson7Title

lesson8Title

lesson9Title

lesson10Title

sqlIntroBasicChapter3Title

sqlIntroBasicChapter1Title

lesson11Title

sqlIntroBasicChapter2Title

-- View all client orders
SELECT *
FROM client_orders;

-- Find the average order total
SELECT AVG(order_total)
FROM client_orders;

-- Get the highest order amount
SELECT MAX(order_total)
FROM client_orders;

-- Get the smallest order amount
SELECT MIN(order_total)
FROM client_orders;

-- Combine all three into a summary
SELECT AVG(order_total) AS avg_order,
  MAX(order_total) AS highest_order,
  MIN(order_total) AS lowest_order
FROM client_orders;

# `AVG`, `MAX`, `MIN`

SQL provides aggregate functions to calculate *average*, *maximum*, and *minimum* values across rows of numeric data.
These functions are commonly used in analytics, reporting, and performance tracking.

<br/>

## `AVG()`: Average Value

The `AVG()` function returns the **average** value from a numeric column.

```sql title="Calculate average order total"
SELECT AVG(order_total)
FROM client_orders;
```

This returns the average order value from all client orders.

> *Note*: `AVG()` automatically ignores `NULL` values when calculating the average.

<br/>

## `MAX()`: Highest Value

The `MAX()` function returns the **highest value** found in a numeric column.

```sql title="Find largest order total"
SELECT MAX(order_total)
FROM client_orders;
```

This query returns the largest order total recorded.

<br/>

## `MIN()`: Lowest Value

The `MIN()` function returns the **lowest value** found in a numeric column.

```sql title="Find smallest order total"
SELECT MIN(order_total)
FROM client_orders;
```
This query returns the smallest order amount recorded.

The `MIN()` function is used in SQL to find the minimum or smallest value in a column of numeric data. This is particularly useful for identifying the least expensive order or the smallest numerical entry in your dataset.

### What SQL function would you use to find the smallest value in a set of data?

AVG, MAX, MIN

AVG(): Average Value

MAX(): Highest Value

MIN(): Lowest Value

What SQL function would you use to find the smallest value in a set of data?

`AVG`, `MAX`, `MIN`

`AVG()`: Average Value

`MAX()`: Highest Value

`MIN()`: Lowest Value