Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table ta (title varchar2(20), status varchar2(20) );
  
begin
Insert Into ta (title,status) Values ('worker', 'ready');
Insert Into ta (title,status) Values ('worker', 'ready');
Insert Into ta (title,status) Values ('worker', 'ready');
Insert Into ta (title,status) Values ('worker', 'started');
Insert Into ta (title,status) Values ('worker', 'started');
Insert Into ta (title,status) Values ('worker', 'started');
Insert Into ta (title,status) Values ('worker', 'finished');
Insert Into ta (title,status) Values ('worker', 'finished');
Insert Into ta (title,status) Values ('worker', 'finished');
Insert Into ta (title,status) Values ('worker', 'finished');

Insert Into ta (title,status) Values ('manager', 'ready');
Insert Into ta (title,status) Values ('manager', 'ready');
Insert Into ta (title,status) Values ('manager', 'ready');
Insert Into ta (title,status) Values ('manager', 'ready');
Insert Into ta (title,status) Values ('manager', 'started');
Insert Into ta (title,status) Values ('manager', 'finished');
Insert Into ta (title,status) Values ('manager', 'finished');
Insert Into ta (title,status) Values ('manager', 'finished');
Insert Into ta (title,status) Values ('manager', 'finished');
Insert Into ta (title,status) Values ('manager', 'finished');
end;
/
1 rows affected

select q.*, worker + manager as total 
  from ta
 pivot 
 (
  count(title)
  for title in ( 'worker' as worker, 'manager' as manager ) 
 ) q
 


STATUS
WORKER
MANAGER
TOTAL


started
3
1
4

finished
4
5
9

ready
3
4
7