combine_all_avg.sql 228 B

12345678910111213
  1. USE plato;
  2. SELECT
  3. avg(key),
  4. avg(cast(key as int8)),
  5. avg(cast(key as uint16)),
  6. avg(cast(key as int32)),
  7. avg(1u/0u),
  8. avg(2),
  9. avg(if(key=10u,key)),
  10. avg(if(key=100u,key)),
  11. avg(key=10u)
  12. FROM Input