yql/essentials/tests/sql/suites/optimizers/unused_columns_group.sql


1
2
3
4
5
6
7
8
9

USE plato;

select a,bb from (
select a,count(distinct b) as bb,max(c) as cc,median(c) as cc1,percentile(c,0.8) as cc2 from (
select a,b,cast(c as int32) as c,d from Input
)
group by a
)
order by a