Learn

Date, Number, and String Functions

Numbers II

A couple more useful numeric SQL functions are included below: `MAX`

and `MIN`

.

`MAX(n1,n2,n3,...)`

: returns the greatest value in the set of the input numeric expressions
`MIN(n1,n2,n3,...)`

: returns the least value in the set of the input numeric expressions

In our `baked_goods`

table, in addition to the numeric `ingredients_cost`

we have information about the packaging cost located in the `packaging_cost`

column. We can use the `MAX`

function to determine the overall greatest value of cost for each item using the following query:

```
SELECT id, MAX(ingredients_cost, packaging_cost)
FROM baked_goods;
```

We also have information about cook time designated as `cook_time`

and cool down time designated as `cool_down_time`

in the `baked_goods`

table. Find the greatest time value for each item in the table.

Find the least time value for each item in the table.