avg_and_sum_float.sql 161 B

12345678
  1. /* syntax version 1 */
  2. select
  3. key,
  4. avg(cast(subkey as Float)) as avg,
  5. sum(cast(subkey as Float)) as sum,
  6. from plato.Input
  7. group by key
  8. order by key;