-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical GDP contributions of cities and realistic temperature ranges for sports events, ensuring a diverse set of cities and conditions.

-- Realistic data for city
INSERT INTO city (city_id, GDP) VALUES (1, 1500.0);
INSERT INTO city (city_id, GDP) VALUES (2, 2500.0);
INSERT INTO city (city_id, GDP) VALUES (3, 1800.0);

-- Realistic data for temperature
INSERT INTO temperature (city_id, month, min_temp, max_temp) VALUES (1, 'Jan', 16.0, 24.0);
INSERT INTO temperature (city_id, month, min_temp, max_temp) VALUES (2, 'Jan', 18.0, 26.0);
INSERT INTO temperature (city_id, month, min_temp, max_temp) VALUES (3, 'Jan', 15.0, 23.0);
INSERT INTO temperature (city_id, month, min_temp, max_temp) VALUES (1, 'Feb', 17.0, 25.0);
INSERT INTO temperature (city_id, month, min_temp, max_temp) VALUES (2, 'Feb', 19.0, 27.0);
INSERT INTO temperature (city_id, month, min_temp, max_temp) VALUES (3, 'Feb', 16.0, 24.0);
INSERT INTO temperature (city_id, month, min_temp, max_temp) VALUES (1, 'Mar', 18.0, 26.0);
INSERT INTO temperature (city_id, month, min_temp, max_temp) VALUES (2, 'Mar', 20.0, 28.0);
INSERT INTO temperature (city_id, month, min_temp, max_temp) VALUES (3, 'Mar', 17.0, 25.0);

-- Realistic data for match_allocation
INSERT INTO match_allocation (match_id, city_id, is_allocated) VALUES (1, 1, True);
INSERT INTO match_allocation (match_id, city_id, is_allocated) VALUES (2, 2, True);
INSERT INTO match_allocation (match_id, city_id, is_allocated) VALUES (3, 3, False);

