decimal_avg.sql 172 B

12345678
  1. USE plato;
  2. SELECT
  3. avg(cs_ext_list_price), avg(cs_ext_tax),
  4. avg(cs_ext_list_price) * decimal("1.1", 7, 2),
  5. decimal("1.1", 7, 2) * avg(cs_ext_tax),
  6. FROM Input;