-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical revenue estimates for film distribution in various markets, ensuring a mix of high and low estimates to reflect market variability. Budget limits were set to allow for strategic decision-making without trivializing the optimization problem.

-- Realistic data for film_market_estimation
INSERT INTO film_market_estimation (film_id, market_id, Low_Estimate, High_Estimate) VALUES (1, 101, 12000.0, 18000.0);
INSERT INTO film_market_estimation (film_id, market_id, Low_Estimate, High_Estimate) VALUES (1, 102, 15000.0, 22000.0);
INSERT INTO film_market_estimation (film_id, market_id, Low_Estimate, High_Estimate) VALUES (2, 101, 8000.0, 12000.0);
INSERT INTO film_market_estimation (film_id, market_id, Low_Estimate, High_Estimate) VALUES (2, 103, 20000.0, 30000.0);
INSERT INTO film_market_estimation (film_id, market_id, Low_Estimate, High_Estimate) VALUES (3, 102, 25000.0, 35000.0);

-- Realistic data for film_market_decision
INSERT INTO film_market_decision (film_id, market_id, x) VALUES (1, 101, True);
INSERT INTO film_market_decision (film_id, market_id, x) VALUES (1, 102, False);
INSERT INTO film_market_decision (film_id, market_id, x) VALUES (2, 101, False);
INSERT INTO film_market_decision (film_id, market_id, x) VALUES (2, 103, True);
INSERT INTO film_market_decision (film_id, market_id, x) VALUES (3, 102, True);

