MySQL 5.6

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);

queue_num_curr	count(*)
9001	2
9003	1
9004	1