Categorizing Column fitted_value - Aster Analytics

The fitted_value column gives the probability that a student belongs to one of the output classes. A typical logistic regression graph is displayed, as shown in the following figure, mapping the input x-axis against a y probability value between [0,1].

The fitted_value probability of > = 0.5 implies class 1 (student admitted) and a probability of < 0.5 implies class 0 (student rejected).

The following query returns the following table:

ALTER table glmpredict_admissions
  ADD column fitted_category int;
  UPDATE glmpredict_admissions SET fitted_category = 1
    WHERE fitted_value > 0.4999;
  UPDATE glmpredict_admissions SET fitted_category = 0
    WHERE fitted_value < 0.4999;
SELECT * FROM glmpredict_admissions ORDER BY 1;