The following query returns the output shown in the following table:
SELECT * FROM glmpredict_housing ORDER BY 1;
| sn | price | fitted_value |
|---|---|---|
| 13 | 27000 | 37345.844 |
| 16 | 37900 | 43687.13175 |
| 25 | 42000 | 40902.028 |
| 38 | 67000 | 72487.6705 |
| 53 | 68000 | 79238.6937 |
| 104 | 132000 | 111528.007 |
| 111 | 43000 | 39102.8812 |
| 117 | 93000 | 66936.951 |
| 132 | 44500 | 41819.8865 |
| 140 | 43000 | 41611.7915 |
| ... | ... | ... |
The fitted_value column gives the predicted home price.