Sign in
apache
/
drill-test-framework
/
0c85b4fdd97d4bceb9f295eb434983b210bff100
/
.
/
framework
/
resources
/
Functional
/
limit0
/
hbase
/
data
/
group_by.q
blob: f8bf695595417613ce3ca7fd67edfb1e7bff8358 [
file
] [
log
] [
blame
]
select
cast
(
voter
.
onecf
.
name
as
varchar
(
30
))
name
,
count
(*)
unique_name
from
voter
group
by
voter
.
onecf
.
name having count
(*)
>
3
order
by
voter
.
onecf
.
name
;