---

INSERT INTO rooms (room_id, sector_id, temperature, oxygen_level, capacity_kg) VALUES
-- Sector 1
(1, 1, 1.2, 2.0, 40000),
(2, 1, 1.5, 2.5, 40000),
(3, 1, 0.8, 1.8, 40000),
(4, 1, 1.0, 2.2, 40000),
(5, 1, 1.3, 2.1, 40000),
(6, 1, 0.9, 1.9, 40000),
(7, 1, 1.4, 2.3, 40000),
(8, 1, 1.1, 2.0, 40000),

-- Sector 2
(9, 2, 2.0, 3.0, 40000),
(10, 2, 2.2, 3.2, 40000),
(11, 2, 1.8, 2.8, 40000),
(12, 2, 2.1, 3.1, 40000),
(13, 2, 1.9, 2.9, 40000),
(14, 2, 2.3, 3.3, 40000),
(15, 2, 2.0, 3.0, 40000),
(16, 2, 2.1, 3.1, 40000),

-- Sector 3
(17, 3, 0.5, 1.5, 40000),
(18, 3, 0.7, 1.7, 40000),
(19, 3, 0.6, 1.6, 40000),
(20, 3, 0.8, 1.8, 40000),
(21, 3, 0.4, 1.4, 40000),
(22, 3, 0.9, 1.9, 40000),
(23, 3, 0.6, 1.6, 40000),
(24, 3, 0.7, 1.7, 40000),

-- Sector 4
(25, 4, 3.0, 4.0, 40000),
(26, 4, 3.2, 4.2, 40000),
(27, 4, 2.8, 3.8, 40000),
(28, 4, 3.1, 4.1, 40000),
(29, 4, 3.3, 4.3, 40000),
(30, 4, 2.9, 3.9, 40000),
(31, 4, 3.0, 4.0, 40000),
(32, 4, 3.2, 4.2, 40000);