CREATE TABLE movies ( id INT PRIMARY KEY,
    title VARCHAR(100),
    genre VARCHAR(50),
    release_year INT,
    rating DECIMAL(3, 1),
    box_office DECIMAL(15, 2) ); 
INSERT INTO movies (id, title, genre, release_year, rating, box_office)
    VALUES (1, 'Inception', 'Sci-Fi', 2010, 8.8, 829895144.00),
    (2, 'Titanic', 'Romance', 1997, 7.9, 2187463944.00),
    (3, 'The Dark Knight', 'Action', 2008, 9.0, 1004558444.00),
    (4, 'Interstellar', 'Sci-Fi', 2014, 8.6, 677471339.00), 
    (5, 'Avengers: Endgame', 'Action', 2019, 8.4, 2797800564.00),
    (6, 'The Godfather', 'Crime', 1972, 9.2, 246120974.00),
    (7, 'Joker', 'Crime', 2019, 8.5, 1074251311.00);  

CREATE TABLE directors ( id INT PRIMARY KEY,
    name VARCHAR(100),
    birth_year INT,
    nationality VARCHAR(50),
    oscars_won INT );

-- SELECT COUNT(id) as MovieCount FROM movies;
-- SELECT AVG(rating) AS AverageRating FROM movies;
-- SELECT Max(rating) as HighestRating From movies;
-- SELECT MIN(rating) AS LowestRating FROM movies;
-- SELECT SUM(box_office) AS TotalBoxOffice FROM movies;
-- SELECT AVG(box_office) AS AvgBoxOffice FROM movies;
-- SELECT MAX(box_office) AS HighestBoxOffice FROM movies;
-- SELECT MIN(box_office) AS LowestBoxOffice FROM movies;
-- SELECT Genre, COUNT(id) as MovieCount FROM movies GROUP BY Genre;
-- SELECT Genre, AVG(rating) AS AverageRating FROM movies Group BY Genre ;
-- SELECT Genre, SUM(box_office) AS TotalBoxOffice FROM movies GROUP BY Genre;
-- SELECT Genre, Max(rating) as HighestRating From movies GROUP BY Genre;
-- SELECT DISTINCT genre FROM movies;