Postgres 13

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

create table stud(key serial primary key,id int, type_name text,updated_by text,updated date, 
text_data text,int_data int);

insert into stud ( id,type_name,updated_by,int_data,updated) select 1,'Math','Alex',8,'01/04/2022';
insert into stud ( id,type_name,updated_by,int_data,updated) select 1,'Math','Peter',5,'20/04/2022';
insert into stud ( id,type_name,updated_by,int_data,updated) select 1,'English','Peter',9,'03/04/2022';
insert into stud ( id,type_name,updated_by,int_data,updated) select 1,'Social','Tokaver',7,'07/04/2022';
insert into stud ( id,type_name,updated_by,int_data,updated) select 1,'Science','Machel',9,'01/04/2022';
insert into stud ( id,type_name,updated_by,int_data,updated) select 1,'Science','Machel',4,'21/04/2022';

insert into stud ( id,type_name,updated_by,text_data,updated) select 1,'Name','X','A','01/04/2022';
insert into stud ( id,type_name,updated_by,text_data,updated) select 2,'Name','X','B','01/04/2022';
insert into stud ( id,type_name,updated_by,text_data,updated) select 3,'Name','X','C','01/04/2022';

insert into stud ( id,type_name,updated_by,int_data,updated) select 2,'Math','Alex',9,'01/04/2022';
insert into stud ( id,type_name,updated_by,int_data,updated) select 2,'English','Peter',8,'01/04/2022';
insert into stud ( id,type_name,updated_by,int_data,updated) select 2,'Social','Tokaver',6,'01/04/2022';
insert into stud ( id,type_name,updated_by,int_data,updated) select 2,'Social','Tokaver',9,'20/04/2022';
insert into stud ( id,type_name,updated_by,int_data,updated) select 2,'Science','Machel',5,'01/04/2022';

SELECT * FROM stud

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

1 rows affected

key	id	type_name	updated_by	updated	text_data	int_data
1	1	Math	Alex	2022-04-01	null	8
2	1	Math	Peter	2022-04-20	null	5
3	1	English	Peter	2022-04-03	null	9
4	1	Social	Tokaver	2022-04-07	null	7
5	1	Science	Machel	2022-04-01	null	9
6	1	Science	Machel	2022-04-21	null	4
7	1	Name	X	2022-04-01	A	null
8	2	Name	X	2022-04-01	B	null
9	3	Name	X	2022-04-01	C	null
10	2	Math	Alex	2022-04-01	null	9
11	2	English	Peter	2022-04-01	null	8
12	2	Social	Tokaver	2022-04-01	null	6
13	2	Social	Tokaver	2022-04-20	null	9
14	2	Science	Machel	2022-04-01	null	5

id	Name	Math	English	Social	Science
1	A	8,5	9	7	9,4
2	B	9	8	6,9	5
3	C	null	null	null	null