By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table numbers as
select 1 as A, 3 as B union all
select 4 as A, 4 as B union all
select 5 as A, 5 as B
Records: 3 Duplicates: 0 Warnings: 0
ALTER TABLE numbers ADD C VARCHAR(50) GENERATED ALWAYS AS (A / B);
Records: 0 Duplicates: 0 Warnings: 0
select * from numbers;
| A | B | C |
|---|---|---|
| 1 | 3 | 0.333333333 |
| 4 | 4 | 1.000000000 |
| 5 | 5 | 1.000000000 |