/* postgres can not */
select subkey, HISTOGRAM(cast(key as uint32) % 10, 2.) over w1 as hh, count(key) over w1 as c, min(key) over w1 as mink, max(key) over w1 as maxk
from plato.Input
window w1 as (partition by subkey order by key)
order by subkey, c;