Notes

-- select title from films, list the movies released in 2020; calculate the profit made by each film in the film table; what are the movies to be released in 2020 and have the highest rating; what are the movies released in 2020 and have rating below 9, list the movies that have a release year other than 2020, arrange the list according to the descending order of release year, what are the top 5 latest movies in the list, add a new entry for oppenhimer into the table for the above details, correct the release year of the movie added to be 2024 instead of 2023, count the number of movies released in a year, add a new column director_name and fill the entries, find out the total budget consumed from the table film, find out the name gross and rating of a film,delete the director's column.

CREATE TABLE films (
id SERIAL PRIMARY KEY,
title VARCHAR(255),
release_year INT,
profit DECIMAL(10, 2),
rating DECIMAL(3, 1),
director_name VARCHAR(255),
budget DECIMAL(10, 2)
);

INSERT INTO films (title, release_year, profit, rating, director_name, budget)
VALUES
('The Shawshank Redemption', 1994, 28341469.00, 9.3, 'Frank Darabont', 25000000.00),
('The Godfather', 1972, 245066411.00, 9.2, 'Francis Ford Coppola', 7000000.00),
('The Dark Knight', 2008, 1004558444.00, 9.0, 'Christopher Nolan', 185000000.00),
('Pulp Fiction', 1994, 213928762.00, 8.9, 'Quentin Tarantino', 8000000.00),
('Schindler''s List', 1993, 321365567.00, 8.9, 'Steven Spielberg', 22000000.00),
('Forrest Gump', 1994, 678226000.00, 8.8, 'Robert Zemeckis', 55000000.00),
('The Matrix', 1999, 465343787.00, 8.7, 'The Wachowskis', 63000000.00),
('Inception', 2010, 829895144.00, 8.8, 'Christopher Nolan', 160000000.00);