combine_hashed_count.sql 156 B

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