CREATE TABLE shard_Test ON CLUSTER `{cluster}`
(
    `a` String,
    `b` Float64,
    `c` Float64,
    `d` Float64,
    `e` Float64 ALIAS b + c,
    `f` Float64 ALIAS c + d
)
ENGINE = MergeTree
ORDER BY a;

CREATE TABLE Test ON CLUSTER `{cluster}`
(
    `a` String,
    `b` Float64,
    `c` Float64,
    `d` Float64,
    `e` Float64 ALIAS b + c,
    `f` Float64 ALIAS c + d
)
ENGINE =  Distributed('{cluster}', 'default', 'shard_Test', rand());


INSERT INTO Test VALUES('a', 1,2,3);

SELECT
    e,
    f
FROM Test

   ┌─e─┬─f─┐
1. │ 3 │ 5 │
   └───┴───┘

SELECT
    e,
    f
FROM Test
ORDER BY a ASC


   ┌─e─┬─f─┐
1. │ 5 │ 3 │
   └───┴───┘