Postgres 14

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

create Table  Humans (id int, name text, surname text, year int);

CREATE TABLE


insert into humans
VALUES
  (1, 'Egor', 'Krid', 14),
  (2, 'Dima', 'Maxnin', 12),
  (3, 'Ivan', 'Krid', 12),
  (4, 'Egor', 'Petrenko', 12);

INSERT 0 4


SELECT name, surname, year, count(*) 
FROM Humans
GROUP BY grouping sets( (name), (surname), (year));


name
surname
year
count


Egor
null
null
2

Ivan
null
null
1

Dima
null
null
1

null
Krid
null
2

null
Maxnin
null
1

null
Petrenko
null
1

null
null
14
1

null
null
12
3



SELECT 8

name	surname	year	count
Egor	null	null	2
Ivan	null	null	1
Dima	null	null	1
null	Krid	null	2
null	Maxnin	null	1
null	Petrenko	null	1
null	null	14	1
null	null	12	3