MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE waiter_log
             (call_id varchar(7),
              queue_num_curr integer,
              ast_num_curr integer,
              proceed_wait bit);
INSERT INTO waiter_log
            (call_id,
             queue_num_curr,
             ast_num_curr,
             proceed_wait) VALUES
('f27de4f', 9001, 2, 1),
('f27de4f', 9002, 5, 1),
('f27de4f', 9003, 1, 0),
('asdf231', 9001, 2, 1),
('asdf231', 9002, 5, 1),
('rete125', 9001, 2, 1),
('rete125', 9010, 5, 1),
('a7rf5gs', 9003, 2, 1),
('a7rf5gs', 9006, 5, 1),
('a7rf5gs', 9009, 1, 0),
('qawe234', 9003, 2, 1),
('qawe234', 9008, 5, 1),
('qawe234', 9004, 1, 0),
('49c43ad', 9004, 2, 1),
('49c43ad', 9007, 5, 1);
SELECT wl1.queue_num_curr,
       count(DISTINCT
             (SELECT wl1.call_id
                     FROM dual
                     WHERE NOT EXISTS (SELECT *
                                              FROM waiter_log wl2
                                              WHERE wl2.call_id = wl1.call_id
                                                    AND wl2.proceed_wait = 0))) count
       FROM waiter_log wl1
       GROUP BY wl1.queue_num_curr;


queue_num_curr
count


9001
2

9002
1

9003
0

9004
1

9006
0

9007
1

9008
0

9009
0

9010
1


SELECT wl1.queue_num_curr,
       sum(NOT EXISTS (SELECT *
                              FROM waiter_log wl2
                                   WHERE wl2.call_id = wl1.call_id
                                         AND wl2.proceed_wait = 0)) count
       FROM waiter_log wl1
       GROUP BY wl1.queue_num_curr;


queue_num_curr
count


9001
2

9002
1

9003
0

9004
1

9006
0

9007
1

9008
0

9009
0

9010
1