MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mytable(
   call_id        VARCHAR(8) NOT NULL 
  ,queue_num_curr INTEGER  NOT NULL
  ,ast_num_curr   INTEGER  NOT NULL
  ,proceed_wait   BIT  NOT NULL
);
INSERT INTO mytable(call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('f27de4f',9001,2,1);
INSERT INTO mytable(call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('f27de4f',9002,5,1);
INSERT INTO mytable(call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('f27de4f',9003,1,0);
INSERT INTO mytable(call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('asdf231',9001,2,1);
INSERT INTO mytable(call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('asdf231',9002,5,1);
INSERT INTO mytable(call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('rete125',9001,2,1);
INSERT INTO mytable(call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('rete125',9010,5,1);
INSERT INTO mytable(call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('a7rf5gs',9003,2,1);
INSERT INTO mytable(call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('a7rf5gs',9006,5,1);
INSERT INTO mytable(call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('a7rf5gs',9009,1,0);
INSERT INTO mytable(call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('qawe234',9003,2,1);
INSERT INTO mytable(call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('qawe234',9008,5,1);
INSERT INTO mytable(call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('qawe234',9004,1,0);
INSERT INTO mytable(call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('49c43ad',9004,2,1);
INSERT INTO mytable(call_id,queue_num_curr,ast_num_curr,proceed_wait) VALUES ('49c43ad',9007,5,1);
select *
from (
    select 
        t.*,
        row_number() over(partition by call_id order by queue_num_curr desc) rn,
        min(queue_num_curr) over(partition by call_id) min_queue_num_curr
    from mytable t
) t
where rn = 1
    order by min_queue_num_curr, call_id


call_id
queue_num_curr
ast_num_curr
proceed_wait
rn
min_queue_num_curr


asdf231
9002
5
1
1
9001

f27de4f
9003
1
0
1
9001

rete125
9010
5
1
1
9001

a7rf5gs
9009
1
0
1
9003

qawe234
9008
5
1
1
9003

49c43ad
9007
5
1
1
9004


select 
    min_queue_num_curr queue_num_curr,
    count(*) cnt
from (
    select 
        proceed_wait,
        row_number() over(partition by call_id order by queue_num_curr desc) rn,
        min(queue_num_curr) over(partition by call_id) min_queue_num_curr
    from mytable
) t
where rn = 1 and proceed_wait = 1
group by min_queue_num_curr
order by min_queue_num_curr


queue_num_curr
cnt


9001
2

9003
1

9004
1
call_id	queue_num_curr	ast_num_curr	proceed_wait	rn	min_queue_num_curr
asdf231	9002	5	1	1	9001
f27de4f	9003	1	0	1	9001
rete125	9010	5	1	1	9001
a7rf5gs	9009	1	0	1	9003
qawe234	9008	5	1	1	9003
49c43ad	9007	5	1	1	9004