。。。。。b1 as(

SELECT a2.*,ROW_NUMBER() OVER (ORDER BY a2.Convergence) AS seq  FROM a2

WHERE  TRUNC(a2.hw_trading_hours_max)>=to_date('2025-07-01','yyyy-mm-dd') AND TRUNC(a2.hw_trading_hours_max) <=to_date('2025-07-01','yyyy-mm-dd') AND NOT REGEXP_LIKE(a2.taskno, '^(CX|CY|PX)') AND 

a2.itemcode NOT LIKE '%C'  

     ORDER BY a2.Convergence

),

b2 as(

SELECT a2.*,ROW_NUMBER() OVER (ORDER BY a2.Convergence) AS seq  FROM a2

WHERE  TRUNC(a2.hw_trading_hours_max)>=to_date('2025-07-01','yyyy-mm-dd') AND  TRUNC(a2.hw_trading_hours_max)<=to_date('2025-07-02','yyyy-mm-dd') AND NOT REGEXP_LIKE(a2.taskno, '^(CX|CY|PX)') AND 

a2.itemcode NOT LIKE '%C'  

     ORDER BY a2.Convergence

),

b3 as(

SELECT a2.*,ROW_NUMBER() OVER (ORDER BY a2.Convergence) AS seq  FROM a2

WHERE  TRUNC(a2.hw_trading_hours_max)>=to_date('2025-07-01','yyyy-mm-dd') AND  TRUNC(a2.hw_trading_hours_max)<=to_date('2025-07-03','yyyy-mm-dd') AND NOT REGEXP_LIKE(a2.taskno, '^(CX|CY|PX)') AND 

a2.itemcode NOT LIKE '%C'  

     ORDER BY a2.Convergence

)

SELECT Convergence,'2025-07-01' FROM b1 WHERE seq = (SELECT ROUND(count(1)*0.95) FROM b1)  union

SELECT Convergence,'2025-07-02' FROM b2 WHERE seq = (SELECT ROUND(count(1)*0.95) FROM b2)  union

SELECT Convergence,'2025-07-03' FROM b3 WHERE seq = (SELECT ROUND(count(1)*0.95) FROM b3)前面查出数据明细和日期，怎么计算累计数据条数以及每天的累计数乘0.95取整后的那一条数据，这个数是要先排序后再取