sql plus oracle

The tables are genre, developer, game

Display all of the games that are cheaper than the game 'Death Stranding' and are the same genre as the game 'Team Fortress'?

Display the name of all developers that are worth more than the average net worth of developers who develop shooter games.

Display all the games who belong to a genre that has 3 or more games.

Display the name of the developer who has the most expensive game.

Display the number of games per genre and the genre name.

Display the name of the developers who have the most number of games

Display the name of games that can be played on any platform and their price is greater than the cheapest game.

Display the name of all games whose developers name length is more than 6 characters.

Display the average price of games per developer along with the developer name.

TABLES ARE BELOW

Drop table genre cascade constraints; Drop table developer cascade constraints; Drop table game cascade constraints; ------------------------------------------------------------------------------------------------------------------------------ CREATE TABLE genre(genre_id NUMBER(2) PRIMARY KEY,genre_name VARCHAR2(40)); ------------------------------------------------------------------------------------------------------------------------------ CREATE TABLE developer(dev_id NUMBER(2) PRIMARY KEY,dev_name VARCHAR2(20),founded_date DATE, net_worth NUMBER(4), genre_id NUMBER(2) REFERENCES genre(genre_id)); ------------------------------------------------------------------------------------------------------------------------------ CREATE TABLE game(game_id NUMBER(4) PRIMARY KEY,game_name VARCHAR2(40),platform VARCHAR2(10), price NUMBER(2),developer_id NUMBER(2) REFERENCES developer(dev_id), genre_id NUMBER(2) REFERENCES genre(genre_id)); ------------------------------------------------------------------------------------------------------------------------------ insert into genre values(1,'RPG'); insert into genre values(2,'Shooter'); insert into genre values(3,'MOBA'); insert into genre values(4,'Driving'); ------------------------------------------------------------------------------------------------------------------------------ insert into developer values(1,'fromsoftware','01-nov-1986',45,1); insert into developer values(2,'Kojima Productions','16-dec-2015',30,2); insert into developer values(3,'Valve','24-aug-1996',2000,2); insert into developer values(4,'Rockstar','01-dec-1998',3000,4); insert into developer values(5,'Santa Monica Studio','01-jan-1999',40,1); ------------------------------------------------------------------------------------------------------------------------------ insert into game values(1,'Sekiro: Shadows Die Twice','ps',40,1,1); insert into game values(2,'Bloodborne','all',40,1,1); insert into game values(3,'Dark Souls','all',45,1,1); insert into game values(4,'Death Stranding','all',39,2,2); insert into game values(5,'Metal Gear Solid V: The Phantom Pain','all',20,2,2); insert into game values(6,'Half-life','pc',10,3,2); insert into game values(7,'Counter Strike ','pc',15,3,2); insert into game values(8,'Team Fortress','pc',10,3,2); insert into game values(9,'Grand Theft Auto','all',50,4,4); insert into game values(10,'Red Dead Redemption','ps',59,4,1); insert into game values(11,'Dota','pc',0,3,3); commit;