Sign in
apache
/
drill-test-framework
/
9a5d7ecf7f32f0e95c0ea874e75d785fdee9e51d
/
.
/
framework
/
resources
/
Functional
/
aggregates
/
aggregation
/
sanity
/
q16.sql
blob: ffca4931343a1976c2acd7146ebe46bf409c1b75 [
file
] [
log
] [
blame
]
select
count
(
distinct
t1
.
a1
),
count
(*)
from
t1
inner
join
t2
on
t1
.
a1
=
t2
.
a2
group
by
t1
.
b1
;