group_by_complex_key.sql 214 B

12345678910111213141516
  1. USE plato;
  2. $src =
  3. SELECT
  4. if (key != '075', AsTuple(Just(Just(key)), 123)) as k,
  5. subkey,
  6. value
  7. FROM Input;
  8. SELECT
  9. k,
  10. min(subkey) as min,
  11. max(value) as max,
  12. FROM $src
  13. GROUP by k
  14. ORDER by k