unused_columns_group.sql 197 B

123456789
  1. USE plato;
  2. select a,bb from (
  3. select a,count(distinct b) as bb,max(c) as cc,median(c) as cc1,percentile(c,0.8) as cc2 from (
  4. select a,b,cast(c as int32) as c,d from Input
  5. )
  6. group by a
  7. )
  8. order by a