CREATE TABLE franchises (
    Franchise VARCHAR(50),
    inception_year YEAR,
    total_revenue_busd DECIMAL(4,1),
    original_medium VARCHAR(20),
    owner VARCHAR(50),
    n_movies INT
);

INSERT INTO franchises (Franchise, inception_year, total_revenue_busd, original_medium, owner, n_movies) VALUES
('Star Wars', 1977, 46.7, 'movie', 'The Walt Disney Company', 12),
('Mickey Mouse and Friends', 1928, 52.2, 'cartoon', 'The Walt Disney Company', NULL),
('Anpanman', 1973, 38.4, 'book', 'Froebel-kan', 33),
('Winnie the Pooh', 1924, 48.5, 'book', 'The Walt Disney Company', 6),
('Pokémon', 1996, 88.0, 'video game', 'The Pokémon Company', 24),
('Disney Princess', 2000, 45.4, 'movie', 'The Walt Disney Company', NULL);

SELECT * FROM franchises;