关于一个SQL话语,困惑了,求指导

--1. 构建测试表test id 范围为 0 -- 178 SQL> create table test (id) as select trunc(dbms_random.value(0,179)) from dual connect by level < 10000 ;Table created.--2. 构建范围表range_ SQL> create table range_ ( begin_ number , end_ number , id number) ;Table created.SQL> insert into range_ values (0,27,1) ;1 row created.SQL> insert into range_ values (27,48,2) ;1 row created.SQL> insert into range_ values (48,96,3) ;1 row created.SQL> insert into range_ values (96,111,4) ;1 row created.SQL> insert into range_ values (111,178,5) ;1 row created.SQL> commit ;Commit complete.SQL> select * from range_ order by id ;    BEGIN_       END_         ID---------- ---------- ----------         0         27          1        27         48          2        48         96          3        96        111          4       111        178          5--目标 根据 范围表 range_ 的列 begin_ end_ 统计 test 表中的数据分布情况 --目标结果集举例:     BEGIN_       END_         ID   COUNT---------- ---------- ---------- -------         0         27          1    2000        27         48          2    1999          48         96          3    2001        96        111          4    1888       111        178          5    2111

  select r.*,         (select count(*)            from test t           where (t.id > r.begin_             and t.id <= r.end_) --不是从0开始的计数             or (t.id >= r.begin_             and t.id <= r.end_ and r.begin_=0)--从0开始的计数             ) as count    from range_ r;