-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were determined based on typical business operations for handling customer complaints, considering average resolution times and staff capacity in a medium-sized customer service department.

-- Realistic data for Complaints
INSERT INTO Complaints (complaint_id, date_complaint_raised, date_complaint_closed, resolution_time) VALUES (1, 2023-01-01, 2023-01-03, 2);
INSERT INTO Complaints (complaint_id, date_complaint_raised, date_complaint_closed, resolution_time) VALUES (2, 2023-01-02, 2023-01-05, 3);
INSERT INTO Complaints (complaint_id, date_complaint_raised, date_complaint_closed, resolution_time) VALUES (3, 2023-01-03, 2023-01-06, 3);

-- Realistic data for StaffCapacity
INSERT INTO StaffCapacity (staff_id, max_complaints) VALUES (1, 5);
INSERT INTO StaffCapacity (staff_id, max_complaints) VALUES (2, 7);
INSERT INTO StaffCapacity (staff_id, max_complaints) VALUES (3, 6);

