Exercise

# Applying aggregate functions to converted values

As demonstrated in the video exercise, converting a column's value from `TEXT`

to a number allows for calculations to be performed using aggregation functions. The `summons_number`

is of type `TEXT`

in the `parking_violation`

dataset. The maximum (using `MAX(summons_number)`

) and minimum (using `MIN(summons_number)`

) of the `TEXT`

representation `summons_number`

can be calculated. If you, however, want to know the size of the range (max - min) of `summon_number`

values , this calculation is not possible because the operation of subtraction on `TEXT`

types is not defined. First, converting `summons_number`

to a `BIGINT`

will resolve this problem.

In this exercise, you will calculate the size of the range of `summons_number`

values as the difference between the maximum and minimum `summons_number`

.

Instructions

**100 XP**

- Define the
`range_size`

for`summons_number`

as the difference between the maximum`summons_number`

and the minimum of the`summons_number`

using the`summons_number`

column after converting to the`BIGINT`

type.