Size: a a a
AI
SELECT col.1.2 as col.1.1, col.2.2 as col.2.1 FROM (SELECT (('name', 1), ('price', 2)) as col) красота же (нет, можно еще лучше), но и так нельзя (D
SELECT col.1.2 as col.1.1, col.2.2 as col.2.1 FROM (SELECT (('name', 1), ('price', 2)) as col) красота же (нет, можно еще лучше), но и так нельзя (SELECT
name,
priceArr[idx] as price,
avgPrice
from (
SELECT
groupArray(t.name) as nameArr,
groupArray(t.price) as priceArr,
avg(price) as avgPrice
FROM (-- data simulation
SELECT arrayJoin([(3, 'a'), (5, 'b'), (3, 'c'), (3, 'd')]) as col, col.1 as price, col.2 as name
) as t
)
ARRAY JOIN nameArr as name, arrayEnumerate(nameArr) as idx
WHERE price > avgPrice
DC
LB
LB
DC
DT
SELECT col.1.2 as col.1.1, col.2.2 as col.2.1 FROM (SELECT (('name', 1), ('price', 2)) as col) красота же (нет, можно еще лучше), но и так нельзя (DC
groupArray((name, price))groupArray(price), groupArray(name)D
groupArray((name, price))groupArray(price), groupArray(name)DC
D
D
DT
D
LB
Д
DT
Д
Д
DT