blob: 1085d839000f33934446a2e9b0cb72cc9546f218 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
use plato;
SELECT
count(cs_ext_list_price),
sum(cs_ext_tax),
sum(cs_ext_list_price),
min(cs_sales_price),
max(cs_ext_list_price),
avg(cs_ext_tax),
sum(cast(cs_sales_price as float)),
min(cast(cs_ext_list_price as float)),
max(cast(cs_ext_tax as float)),
avg(cast(cs_sales_price as float))
FROM Input
|
