alter table y add js varchar(10) generated always as (case when total <= 100 then 100-total when total > 100 and total <= 200 then 200-total when total >200 and total <= 300 then 300-total when total>300 and total<=400 then 400-total else 1000-total end );