combine_all_decimal.sql 342 B

123456789101112131415
  1. use plato;
  2. SELECT
  3. count(cs_ext_list_price),
  4. sum(cs_ext_tax),
  5. sum(cs_ext_list_price),
  6. min(cs_sales_price),
  7. max(cs_ext_list_price),
  8. avg(cs_ext_tax),
  9. sum(cast(cs_sales_price as float)),
  10. min(cast(cs_ext_list_price as float)),
  11. max(cast(cs_ext_tax as float)),
  12. avg(cast(cs_sales_price as float))
  13. FROM Input