By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | name | unknown1 | unknown2 |
|---|---|---|---|
| 1 | 11 | 111 | 1111 |
| 2 | 22 | 123 | 1234 |
| 3 | 33 | 333 | 5678 |
| sum1 | sum2 |
|---|---|
| 567 | 8023 |
| @sql |
|---|
| SELECT 'unknown1' Columns, SUM(`unknown1`) Total FROM db_614525567.test UNION ALL SELECT 'unknown2' Columns, SUM(`unknown2`) Total FROM db_614525567.test |
| Columns | Total |
|---|---|
| unknown1 | 567 |
| unknown2 | 8023 |