给定一个如下所示的数据集：

-------------------------------
- id -      mac       - time  - 
- 1  - aa:bb:cc:dd:ee - 9pm   - 
- 2  - aa:bb:cc:dd:ee - 9pm   - 
- 3  - aa:bb:cc:dd:ee - 10pm  - 
- 4  - aa:11:cc:dd:ee - 10pm  - 
- 5  - aa:11:cc:dd:ee - 10pm  - 
- 6  - aa:bb:cc:dd:ee - 11pm  - 
- 7  - aa:11:cc:dd:ee - 11pm  - 
- 8  - aa:11:cc:dd:ee - 11pm  - 
- 9  - 22:11:cc:dd:ee - 12pm  - 
-------------------------------

什么查询会产生如下输出：

-------------------------------------------------------------------------------
- time - total - new(2 or more) - passerby(1) - returning(existed previously) -
-  9pm -   1   -   1            -     0       -           0                   -
- 10pm -   2   -   1            -     0       -           1                   -
- 11pm -   2   -   0            -     0       -           2                   -
- 12pm -   1   -   0            -     1       -           0                   -
-------------------------------------------------------------------------------