Query Set #7a – imputing missing temperature values using normal-range imputation

Here, we use an UPDATE statement to set the temperature variable to 98.6 where it is missing:

sqlite> UPDATE MORT_FINAL_2 SET Temp_f = 98.6
WHERE Temp_f IS NULL;