Table structure as
UserID Col col2 zt zt2
1 aaa 2 standard null
2 aaa 3 empty values are not standard
3 bb 2 make null
4 bb 4 empty value standard
The desired results are as follows:
1 aaa five standard not standard
2 bb 6 substandard housing standard


Thank you