SQLite 3.27

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

CREATE TABLE table1 (
  ID VARCHAR(2),
  Col_1 VARCHAR(1),
  Col_2 VARCHAR(1),
  Col_3 VARCHAR(1),
  Col_4 VARCHAR(1)
);
INSERT INTO table1
  (ID, Col_1, Col_2, Col_3, Col_4)
VALUES
  ('01', 'A', 'Q', 'R', 'U'),
  ('02', 'A', 'Q', 'R', 'P'),
  ('03', 'A', 'Q', 'R', 'U'),
  ('04', 'A', 'Q', 'R', 'P'),
  ('05', 'A', 'Q', 'T', 'U'),
  ('06', 'A', 'Q', 'T', 'P'),
  ('07', 'A', 'Q', 'T', 'U'),
  ('08', 'A', 'Q', 'T', 'P'),
  ('09', 'A', 'Q', 'R', 'U'),
  ('10', 'B', 'Q', 'R', 'P'),
  ('11', 'B', 'Q', 'R', 'U'),
  ('12', 'B', 'Q', 'R', 'P'),
  ('13', 'B', 'Q', 'T', 'U'),
  ('14', 'C', 'Q', 'T', 'P'),
  ('15', 'C', 'Q', 'T', 'U'),
  ('16', 'C', 'Q', 'T', 'U'),
  ('17', 'C', 'Q', 'R', 'P'),
  ('18', 'C', 'Q', 'R', 'U'),
  ('19', 'C', 'Q', 'R', 'P'),
  ('20', 'C', 'Q', 'R', 'U');
SELECT ID,
       COUNT(*) OVER (PARTITION BY Col_1) Col_1,
       COUNT(*) OVER (PARTITION BY Col_1, Col_2) Col_2,
       COUNT(*) OVER (PARTITION BY Col_1, Col_2, Col_3) Col_3,
       COUNT(*) OVER (PARTITION BY Col_1, Col_2, Col_3, Col_4) Col_4
FROM table1
ORDER BY ID


ID
Col_1
Col_2
Col_3
Col_4


01
9
9
5
3

02
9
9
5
2

03
9
9
5
3

04
9
9
5
2

05
9
9
4
2

06
9
9
4
2

07
9
9
4
2

08
9
9
4
2

09
9
9
5
3

10
4
4
3
2

11
4
4
3
1

12
4
4
3
2

13
4
4
1
1

14
7
7
3
1

15
7
7
3
2

16
7
7
3
2

17
7
7
4
2

18
7
7
4
2

19
7
7
4
2

20
7
7
4
2

ID	Col_1	Col_2	Col_3	Col_4
01	9	9	5	3
02	9	9	5	2
03	9	9	5	3
04	9	9	5	2
05	9	9	4	2
06	9	9	4	2
07	9	9	4	2
08	9	9	4	2
09	9	9	5	3
10	4	4	3	2
11	4	4	3	1
12	4	4	3	2
13	4	4	1	1
14	7	7	3	1
15	7	7	3	2
16	7	7	3	2
17	7	7	4	2
18	7	7	4	2
19	7	7	4	2
20	7	7	4	2

ID	Col_1	Col_2	Col_3	Col_4
01	9	9	5	3
02	9	9	5	2
03	9	9	5	3
04	9	9	5	2
05	9	9	4	2
06	9	9	4	2
07	9	9	4	2
08	9	9	4	2
09	9	9	5	3
10	4	4	3	2
11	4	4	3	1
12	4	4	3	2
13	4	4	1	1
14	7	7	3	1
15	7	7	3	2
16	7	7	3	2
17	7	7	4	2
18	7	7	4	2
19	7	7	4	2
20	7	7	4	2

ID	Col_1	Col_2	Col_3	Col_4
01	9	9	5	3
02	9	9	5	2
03	9	9	5	3
04	9	9	5	2
05	9	9	4	2
06	9	9	4	2
07	9	9	4	2
08	9	9	4	2
09	9	9	5	3
10	4	4	3	2
11	4	4	3	1
12	4	4	3	2
13	4	4	1	1
14	7	7	3	1
15	7	7	3	2
16	7	7	3	2
17	7	7	4	2
18	7	7	4	2
19	7	7	4	2
20	7	7	4	2