MySQL 8.0

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

CREATE TABLE `reports` (
  `ReasonID` int(11) DEFAULT NULL,
  `Team` text,
  `Division` text,
  `Location` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO reports (ReasonID,Team,Division,Location) values
(2, 'A', null, 'L1'),
(3, 'B', 'D1', 'L2'),
(2, 'A', 'D2', 'L1'),
(2, 'A', 'D3', 'L3');
select
  reasonid,
  team,
  count(team) over (partition by team) as total_by_team,
  location,
  count(location) over (partition by location) as total_by_location,
  division,
  count(division) over (partition by division) as total_by_division
from reports;


reasonid
team
total_by_team
location
total_by_location
division
total_by_division


2
A
3
L1
2
null
0

3
B
1
L2
1
D1
1

2
A
3
L1
2
D2
1

2
A
3
L3
1
D3
1