CREATE TABLE inspections (
    year INTEGER,
    waterbodyke VARCHAR(50),
    boats_inspectedok INTEGER,
    boats_decontaminatedok INTEGER,
    positive_detectionsok INTEGER,
    program_costok INTEGER
);

INSERT INTO inspections VALUES
(2021, 'Lake A', 8500, 125, 0, 185000),
(2022, 'Lake A', 10200, 180, 0, 220000),
(2023, 'Lake A', 12800, 245, 2, 275000),
(2024, 'Lake A', 15100, 390, 5, 340000),
(2021, 'Lake B', 6200, 90, 0, 140000),
(2022, 'Lake B', 7100, 115, 0, 165000),
(2023, 'Lake B', 8500, 175, 1, 210000),
(2024, 'Lake B', 9800, 260, 3, 265000),
(2021, 'Lake C', 4800, 55, 0, 105000),
(2022, 'Lake C', 5300, 70, 0, 125000),
(2023, 'Lake C', 6100, 95, 0, 150000),
(2024, 'Lake C', 7500, 150, 1, 190000);