SQL Server 2019

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

select @@version;


(No column name)


Microsoft SQL Server 2019 (RTM-CU6) (KB4563110) - 15.0.4053.23 (X64) 
 Jul 25 2020 11:26:55 
 Copyright (C) 2019 Microsoft Corporation
 Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



create table job (Job int, Name varchar(10), Active bit)
insert into job values
(123,  'Smith',  1),
(123,  'Brown',  0),
(123,  'Jones',  1),
(123,  'Peters', 1)
4 rows affected

SELECT
  Job,
  SUM(CASE WHEN Active=1 THEN 1 ELSE 0 END) AS Active,
  SUM(CASE WHEN Active=0 THEN 1 ELSE 0 END) AS Inactive,
  COUNT(*) AS Total,
  SUM(CASE WHEN Active=1 THEN 1 ELSE 0 END) * 100.0 / COUNT(*) AS [%Active],
  SUM(CASE WHEN Active=0 THEN 1 ELSE 0 END) * 100.0 / COUNT(*) AS [%Inactive]
FROM
  job
GROUP BY
  Job


Job
Active
Inactive
Total
%Active
%Inactive


123
3
1
4
75.000000000000
25.000000000000