functions.plsql

-- call the replace function on the `response_type` column
-- which will replace the string 'Medic' with 'Medical'
replace(`response_type`, 'Medic', 'Medical')

-- call the to_number function on the `latitude` column
to_number(`latitude`)

-- call the to_boolean function on the incident column. Note we don't need the 
-- `backticks` when the column name is alphanumeric+underscores.
to_boolean(incident_number)