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 are useful for analytics, reporting, and decision-making.

<br/>

## `AVG()`: Average Value

The `AVG()` function calculates the average value of 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.

> ⚠️ Null values are ignored in the average calculation.

<br/>

## `MAX()`: Highest Value

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

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

Returns the highest order total recorded.

<br/>

## `MIN()`: Lowest Value

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

```sql title="Find smallest order total"
SELECT MIN(order_total)
FROM client_orders;
```

Returns the smallest (minimum) order amount.

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()`: Average Value

`MAX()`: Highest Value

`MIN()`: Lowest Value