CREATE TABLE PopulationData (
    HHSRegion NVARCHAR(100) NOT NULL,
    AgeGroup NVARCHAR(50) NOT NULL,
    Population INT NOT NULL
);

INSERT INTO PopulationData (HHSRegion, AgeGroup, Population)
VALUES
    -- Data for United States
    ('United States', '85 years and over', 800000),
    ('United States', '5-17 years', 3000000),
    ('United States', '40-49 years', 3500000),
    ('United States', '0-4 years', 2000000),
    ('United States', '50-64 years', 4500000),
    ('United States', '75-84 years', 1500000),
    ('United States', '18-29 years', 5000000),
    ('United States', '65-74 years', 2500000),
    ('United States', '30-39 years', 4000000),

    -- Data for other regions
    ('07', '85 years and over', 100000),
    ('07', '5-17 years', 500000),
    ('07', '40-49 years', 600000),
    ('07', '0-4 years', 300000),
    ('07', '50-64 years', 700000),
    ('07', '75-84 years', 200000),
    ('07', '18-29 years', 800000),
    ('07', '65-74 years', 400000),
    ('07', '30-39 years', 500000),

    ('08', '85 years and over', 120000),
    ('08', '5-17 years', 520000),
    ('08', '40-49 years', 610000),
    ('08', '0-4 years', 320000),
    ('08', '50-64 years', 750000),
    ('08', '75-84 years', 210000),
    ('08', '18-29 years', 850000),
    ('08', '65-74 years', 450000),
    ('08', '30-39 years', 520000),

    ('02', '85 years and over', 90000),
    ('02', '5-17 years', 450000),
    ('02', '40-49 years', 480000),
    ('02', '0-4 years', 250000),
    ('02', '50-64 years', 670000),
    ('02', '75-84 years', 150000),
    ('02', '18-29 years', 750000),
    ('02', '65-74 years', 350000),
    ('02', '30-39 years', 500000),

    ('06', '85 years and over', 95000),
    ('06', '5-17 years', 480000),
    ('06', '40-49 years', 590000),
    ('06', '0-4 years', 290000),
    ('06', '50-64 years', 680000),
    ('06', '75-84 years', 170000),
    ('06', '18-29 years', 770000),
    ('06', '65-74 years', 380000),
    ('06', '30-39 years', 510000),

    ('03', '85 years and over', 89000),
    ('03', '5-17 years', 460000),
    ('03', '40-49 years', 570000),
    ('03', '0-4 years', 270000),
    ('03', '50-64 years', 640000),
    ('03', '75-84 years', 140000),
    ('03', '18-29 years', 730000),
    ('03', '65-74 years', 360000),
    ('03', '30-39 years', 490000),

    ('04', '85 years and over', 91000),
    ('04', '5-17 years', 470000),
    ('04', '40-49 years', 580000),
    ('04', '0-4 years', 280000),
    ('04', '50-64 years', 660000),
    ('04', '75-84 years', 160000),
    ('04', '18-29 years', 740000),
    ('04', '65-74 years', 370000),
    ('04', '30-39 years', 500000),

    ('05', '85 years and over', 92000),
    ('05', '5-17 years', 490000),
    ('05', '40-49 years', 600000),
    ('05', '0-4 years', 300000),
    ('05', '50-64 years', 680000),
    ('05', '75-84 years', 180000),
    ('05', '18-29 years', 760000),
    ('05', '65-74 years', 400000),
    ('05', '30-39 years', 520000),

    ('10', '85 years and over', 91000),
    ('10', '5-17 years', 470000),
    ('10', '40-49 years', 590000),
    ('10', '0-4 years', 280000),
    ('10', '50-64 years', 670000),
    ('10', '75-84 years', 170000),
    ('10', '18-29 years', 750000),
    ('10', '65-74 years', 380000),
    ('10', '30-39 years', 510000),

    ('01', '85 years and over', 93000),
    ('01', '5-17 years', 490000),
    ('01', '40-49 years', 610000),
    ('01', '0-4 years', 310000),
    ('01', '50-64 years', 700000),
    ('01', '75-84 years', 190000),
    ('01', '18-29 years', 780000),
    ('01', '65-74 years', 420000),
    ('01', '30-39 years', 530000),

    ('09', '85 years and over', 88000),
    ('09', '5-17 years', 440000),
    ('09', '40-49 years', 570000),
    ('09', '0-4 years', 260000),
    ('09', '50-64 years', 620000),
    ('09', '75-84 years', 130000),
    ('09', '18-29 years', 720000),
    ('09', '65-74 years', 350000),
    ('09', '30-39 years', 470000);