Sign in
apache
/
drill-test-framework
/
9a5d7ecf7f32f0e95c0ea874e75d785fdee9e51d
/
.
/
framework
/
resources
/
Functional
/
aggregates
/
aggregation
/
count_distinct
/
with_sum_avg_c_bigint_group_by_8_cols.sql
blob: d63a7b9c99c03ba17da9cc2b33332a264ba43ca8 [
file
] [
log
] [
blame
]
select
count
(
distinct
c_bigint
),
sum
(
c_bigint
),
round
(
avg
(
c_bigint
))
from
alltypes_with_nulls
group
by
c_varchar
,
c_integer
,
c_bigint
,
d9
,
d18
,
d28
,
d38
,
c_date
order
by
c_varchar
,
c_integer
,
c_bigint
,
d9
,
d18
,
d28
,
d38
,
c_date
;