Sign in
apache
/
datafusion
/
refs/heads/add-iter-method-to-extensions
/
.
/
benchmarks
/
queries
/
clickbench
/
extended
/
q7.sql
blob: ddaff7f8804f5ed7e257e51405a0aa4863d37af0 [
file
] [
log
] [
blame
]
SELECT
"WatchID"
,
MIN
(
"ResolutionWidth"
)
as
wmin
,
MAX
(
"ResolutionWidth"
)
as
wmax
,
SUM
(
"IsRefresh"
)
as
srefresh
FROM
hits
GROUP
BY
"WatchID"
ORDER
BY
"WatchID"
DESC
LIMIT
10
;