SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table bob(some_type varchar(30), some_count int);

insert into bob values
('Non-Related',1),
('Recruited',0),
('Related (Including Kinship)',1);
3 rows affected

select some_type, some_count,
	sum(some_count) over() total_count
from bob;


some_type
some_count
total_count


Non-Related
1
2

Recruited
0
2

Related (Including Kinship)
1
2


select some_type, some_count,
	round(((some_count+0.0)/sum(some_count) over())*100,2) total_pct
from bob;


some_type
some_count
total_pct


Non-Related
1
50.000000000000

Recruited
0
0.000000000000

Related (Including Kinship)
1
50.000000000000

some_type	some_count	total_pct
Non-Related	1	50.000000000000
Recruited	0	0.000000000000
Related (Including Kinship)	1	50.000000000000