combine_hashed_avg.sql 134 B

1234567891011
  1. USE plato;
  2. SELECT
  3. key,
  4. avg(1u/(4u-subkey)),
  5. avg(subkey),
  6. avg(1u),
  7. avg(1u/0u)
  8. FROM Input
  9. GROUP by key
  10. ORDER by key