如果您的窗口是静态的，例如：
窗口1-12:00:00-12:00:09
窗口2-12:00:10-12:00:19等。
您可以这样做：

-- this counts number of windows per with same number of events
select events_in_window,count(*) windows 
from (
    -- this counts events in each window
    select window ,count(*) events_in_window 
    from (
        -- this rounds all the transactions to windows
        select user_id,from_unixtime(floor(unix_timestamp(trans_time)/10)*10) window
        from table) a 
    group by window) b 
group by events_in_window

注意事务处理时间“舍入”中的“10”。你可以把它改成你需要的任何大小的窗口。