By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mytable(
call_time VARCHAR(20) NOT NULL
,call_id VARCHAR(9) NOT NULL
,queue_num_curr INTEGER NOT NULL
,ast_num_curr INTEGER NOT NULL
,proceed_wait BIT NOT NULL
);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:14:30','f27de4f',9010,2,1);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:14:35','f27de4f',9002,5,1);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:14:41','f27de4f',9003,1,0);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:14:45','asdf231',9010,2,1);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:14:50','asdf231',9002,5,1);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:14:55','rete125',9010,2,1);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:15:00','rete125',9009,5,1);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:15:05','a7rf5gs',9003,2,1);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:15:10','a7rf5gs',9006,5,1);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:15:15','a7rf5gs',9009,1,0);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:15:20','qawe234',9003,2,1);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:15:25','qawe234',9008,5,1);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:15:30','qawe234',9004,1,0);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:15:35','49c43ad',9004,2,1);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:15:41','49c43ad',9007,5,1);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:15:45','bxfdrtr',9010,3,1);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:15:50','bxfdrtr',9012,4,1);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:15:55','tofnt62',9010,5,1);
INSERT INTO mytable(call_time,call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('2019-11-18 08:16:00','tofnt62',9021,1,1);
select t.queue_num_curr, t.ast_num_curr, count(*)
from mytable t
inner join (
select call_id, min(call_time) call_time
from mytable
group by call_id
having max(proceed_wait = 0) = 0
) tmin on tmin.call_id = t.call_id and tmin.call_time = t.call_time
group by t.queue_num_curr, t.ast_num_curr
order by t.queue_num_curr, t.ast_num_curr
| queue_num_curr | ast_num_curr | count(*) |
|---|---|---|
| 9004 | 2 | 1 |
| 9010 | 2 | 2 |
| 9010 | 3 | 1 |
| 9010 | 5 | 1 |