SQL
`NULL` and Aggregate Functions
`NULL` values are ignored in most aggregate functions.  
Aggregate functions that do not ignore `NULL` values include: `first`, `last`, `list`, and `array_agg`. To exclude `NULL` values from those aggregate functions, the [`FILTER` clause](#docs:sql:query_syntax:filter) can be used.  
```sql
CREATE TABLE integers (i INTEGER);
INSERT INTO integers VALUES (1), (10), (NULL);
```  
```sql
SELECT min(i) FROM integers;
```  
```text
1
```  
```sql
SELECT max(i) FROM integers;
```  
```text
10
```