CREATE TABLE honeycomb_game (
    id BIGINT PRIMARY KEY,
    shape VARCHAR(50) NOT NULL,
    average_completion_time NUMERIC(10, 2),
    game_date TIMESTAMPTZ NOT NULL
);

CREATE TABLE monthly_temperatures (
    month INTEGER PRIMARY KEY,
    avg_temperature NUMERIC(10, 2) NOT NULL,
    CONSTRAINT valid_month CHECK (month BETWEEN 1 AND 12)
);

INSERT INTO honeycomb_game
    (id, shape, average_completion_time, game_date)
VALUES
    (1, 'triangle', 6.45, '2025-03-15 05:30:00+05:30'),
    (2, 'circle',   6.75, '2025-03-15 05:30:00+05:30'),
    (3, 'triangle', 7.10, '2024-07-20 10:00:00+05:30'),
    (4, 'circle',   6.20, '2023-01-12 14:00:00+05:30'),
    (5, 'square',   8.05, '2022-07-05 09:15:00+05:30'),
    (6, 'triangle', 5.95, '2021-01-28 16:45:00+05:30'),
    (7, 'circle',   7.35, '2019-03-10 11:30:00+05:30'),
    (8, 'square',   7.80, '2018-07-18 08:20:00+05:30'),
    (9, 'triangle', 6.60, '2010-01-08 13:10:00+05:30'),
    (10, 'circle',  6.90, '2000-07-22 17:00:00+05:30');

INSERT INTO monthly_temperatures
    (month, avg_temperature)
VALUES
    (1,  -2.50),
    (2,   0.00),
    (3,   5.50),
    (4,  12.00),
    (5,  20.00),
    (6,  27.00),
    (7,  30.50),
    (8,  29.00),
    (9,  23.00),
    (10, 15.00),
    (11,  7.00),
    (12,  0.50);