Sign in
apache
/
drill-test-framework
/
9a5d7ecf7f32f0e95c0ea874e75d785fdee9e51d
/
.
/
framework
/
resources
/
Functional
/
aggregates
/
aggregation
/
count_distinct
/
q2.sql
blob: 553e879dda01b837234c3e313509775b96121b12 [
file
] [
log
] [
blame
]
-- with avg
select
a1
,
count
(
distinct
a1
),
avg
(
a1
)
from
t1
group
by
a1
;