Oracle 18c

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

CREATE TABLE movie(
   GENRE  VARCHAR(17) NOT NULL
  ,budget INTEGER  NOT NULL
  ,TITLE  VARCHAR(30) NOT NULL
);
BEGIN
INSERT INTO movie(GENRE,budget,TITLE) VALUES ('Western',1200000,'The Good, the Bad and the Ugly');
INSERT INTO movie(GENRE,budget,TITLE) VALUES ('Horror',806947,'Psycho');
INSERT INTO movie(GENRE,budget,TITLE) VALUES ('Crime',7000000,'The Godfather: Part III');
INSERT INTO movie(GENRE,budget,TITLE) VALUES ('Action',185000000,'The Dark Knight');
INSERT INTO movie(GENRE,budget,TITLE) VALUES ('Drama',26000000,'Philadelphia');
INSERT INTO movie(GENRE,budget,TITLE) VALUES ('Drama',13000000,'In the Name of the Father');
INSERT INTO movie(GENRE,budget,TITLE) VALUES ('Action',150000000,'Batman Begins');
INSERT INTO movie(GENRE,budget,TITLE) VALUES ('Historical',23800000,'The Last Emperor');
INSERT INTO movie(GENRE,budget,TITLE) VALUES ('Science-fiction',5800000,'Planet of the Apes');
INSERT INTO movie(GENRE,budget,TITLE) VALUES ('Crime',7000000,'The Godfather');
INSERT INTO movie(GENRE,budget,TITLE) VALUES ('Action',230000000,'The Dark Knight Rises');
INSERT INTO movie(GENRE,budget,TITLE) VALUES ('Comedy',28000000,'Zoolander');
INSERT INTO movie(GENRE,budget,TITLE) VALUES ('Crime',9000000,'Pulp Fiction');
INSERT INTO movie(GENRE,budget,TITLE) VALUES ('Crime',13000000,'The Godfather: Part II');
INSERT INTO movie(GENRE,budget,TITLE) VALUES ('War',70000000,'Saving Private Ryan');
INSERT INTO movie(GENRE,budget,TITLE) VALUES ('Science-fiction',28000000,'Blader Runner');
INSERT INTO movie(GENRE,budget,TITLE) VALUES ('Drama',33000000,'Gran Torino');
END;
/
1 rows affected

select genre,title, budget
from movie m
where budget = (
    select max(m1.budget)
    from movie m1
    where m1.genre = m.genre
)


GENRE
TITLE
BUDGET


Western
The Good, the Bad and the Ugly
1200000

Horror
Psycho
806947

Historical
The Last Emperor
23800000

Action
The Dark Knight Rises
230000000

Comedy
Zoolander
28000000

Crime
The Godfather: Part II
13000000

War
Saving Private Ryan
70000000

Science-fiction
Blader Runner
28000000

Drama
Gran Torino
33000000

GENRE	TITLE	BUDGET
Western	The Good, the Bad and the Ugly	1200000
Horror	Psycho	806947
Historical	The Last Emperor	23800000
Action	The Dark Knight Rises	230000000
Comedy	Zoolander	28000000
Crime	The Godfather: Part II	13000000
War	Saving Private Ryan	70000000
Science-fiction	Blader Runner	28000000
Drama	Gran Torino	33000000