Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Create Table table_name(name VARCHAR(50), month INT, data_type VARCHAR(50), data_value INT);
Insert All Into table_name Values('raj',7,'max',100)
Into table_name Values('raj',7,'min',20)
Into table_name Values('raj',7,'avg',80)
Into table_name Values('raj',7,'max',90)
Into table_name Values('raj',7,'avg',75)
Into table_name Values('raj',7,'min',30)
Into table_name Values('raj',7,'max',95)
Into table_name Values('raj',7,'avg',70)
Into table_name Values('raj',7,'avg',65)
Into table_name Values('raj',7,'max',85)
Into table_name Values('raj',7,'max',96)
Into table_name Values('raj',7,'avg',70)
Into table_name Values('raj',7,'min',35)
Into table_name Values('raj',7,'min',45)
Into table_name Values('raj',7,'avg',84)
Into table_name Values('dev',8,'max',125)
Into table_name Values('dev',8,'min',35)
Into table_name Values('dev',8,'avg',50)
Into table_name Values('dev',8,'max',120)
Into table_name Values('dev',8,'min',20)
Into table_name Values('dev',8,'avg',70)
Into table_name Values('dev',8,'max',100)
Into table_name Values('dev',8,'min',45)
Into table_name Values('dev',8,'avg',83)
Into table_name Values('dev',8,'max',70)
Into table_name Values('dev',8,'min',58)
Into table_name Values('dev',8,'avg',95)
Into table_name Values('dev',8,'max',110)
Into table_name Values('dev',8,'min',60)
Into table_name Values('dev',8,'avg',90)
Into table_name Values('dev',8,'max',115)
Into table_name Values('dev',8,'min',50)
Into table_name Values('dev',8,'avg',67)
Into table_name Values('dev',8,'max',97)
Into table_name Values('dev',8,'min',45)
Into table_name Values('dev',8,'avg',84)
Select 1 From DUAL;
36 rows affected

SELECT name, month, MAX(CASE data_type WHEN 'max' THEN data_value END) month_max,
                    MIN(CASE data_type WHEN 'min' THEN data_value END) month_min,
                    AVG(CASE data_type WHEN 'avg' THEN data_value END) month_avg  
FROM table_name
GROUP BY name, month
ORDER BY name, month


NAME
MONTH
MONTH_MAX
MONTH_MIN
MONTH_AVG


dev
8
125
20
77

raj
7
100
20
74