-- Get Example Files - sample SQL script (SQLite / ANSI compatible)
-- Fictional outdoor-gear orders for testing database imports.

CREATE TABLE IF NOT EXISTS orders (
  id INTEGER PRIMARY KEY,
  order_code VARCHAR(20) NOT NULL UNIQUE,
  customer VARCHAR(80) NOT NULL,
  email VARCHAR(120) NOT NULL,
  city VARCHAR(60) NOT NULL,
  product VARCHAR(80) NOT NULL,
  quantity INTEGER NOT NULL,
  unit_price DECIMAL(10,2) NOT NULL,
  status VARCHAR(20) NOT NULL,
  order_date DATE NOT NULL,
  department VARCHAR(40) NOT NULL
);

CREATE INDEX IF NOT EXISTS idx_orders_city ON orders (city);
CREATE INDEX IF NOT EXISTS idx_orders_status ON orders (status);

BEGIN TRANSACTION;
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (1, 'ORD-100001', 'Keira Everhart', 'keira.everhart1@example.com', 'Brightmoor', 'Tidewater Binoculars', 1, 38.94, 'processing', '2026-02-12', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (2, 'ORD-100002', 'Quinn Greystone', 'quinn.greystone2@example.com', 'Port Larkin', 'Canvas Daypack', 7, 203.34, 'shipped', '2026-02-18', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (3, 'ORD-100003', 'Bastian Sterling', 'bastian.sterling3@example.com', 'Eastvale', 'Summit Tent 2P', 11, 302.84, 'pending', '2026-10-19', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (4, 'ORD-100004', 'Bastian Hollins', 'bastian.hollins4@example.com', 'Port Larkin', 'Glacier Water Filter', 3, 142.21, 'shipped', '2026-09-04', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (5, 'ORD-100005', 'Rosa Valdez', 'rosa.valdez5@example.com', 'Silverbrook', 'Canvas Daypack', 10, 276.11, 'shipped', '2026-06-04', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (6, 'ORD-100006', 'Samir Brightwater', 'samir.brightwater6@example.com', 'Westmere', 'Summit Tent 2P', 8, 328.03, 'returned', '2026-06-15', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (7, 'ORD-100007', 'Luca Jareth', 'luca.jareth7@example.com', 'Maple Hollow', 'Wildflower Seed Kit', 3, 336.87, 'shipped', '2026-02-19', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (8, 'ORD-100008', 'Quinn Pemberton', 'quinn.pemberton8@example.com', 'Fernwood', 'Meadow Picnic Set', 12, 217.92, 'processing', '2026-02-04', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (9, 'ORD-100009', 'Farid Zeller', 'farid.zeller9@example.com', 'Northwick', 'River Kayak Paddle', 8, 205.02, 'cancelled', '2026-02-25', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (10, 'ORD-100010', 'Keira Whitlock', 'keira.whitlock10@example.com', 'Northwick', 'Pinecrest Sleeping Bag', 8, 280.24, 'returned', '2026-02-27', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (11, 'ORD-100011', 'Ines Pemberton', 'ines.pemberton11@example.com', 'Stonebridge', 'Tidewater Binoculars', 2, 33.35, 'cancelled', '2026-05-21', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (12, 'ORD-100012', 'Jonah Whitlock', 'jonah.whitlock12@example.com', 'Brightmoor', 'Lakeshore Folding Chair', 11, 169.5, 'returned', '2026-06-06', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (13, 'ORD-100013', 'Pavel Brightwater', 'pavel.brightwater13@example.com', 'Maple Hollow', 'Wildflower Seed Kit', 5, 66.0, 'shipped', '2026-07-13', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (14, 'ORD-100014', 'Celia Fairbanks', 'celia.fairbanks14@example.com', 'Harrowgate', 'Cloudlight Hammock', 9, 136.61, 'shipped', '2026-07-28', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (15, 'ORD-100015', 'Wren Northcott', 'wren.northcott15@example.com', 'Northwick', 'Tidewater Binoculars', 7, 459.9, 'shipped', '2026-02-06', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (16, 'ORD-100016', 'Hiro Valdez', 'hiro.valdez16@example.com', 'Maple Hollow', 'Trail Lantern', 8, 399.68, 'shipped', '2026-05-10', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (17, 'ORD-100017', 'Elena Northcott', 'elena.northcott17@example.com', 'Lakeside Falls', 'Meadow Picnic Set', 10, 273.8, 'shipped', '2026-12-28', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (18, 'ORD-100018', 'Olivia Zeller', 'olivia.zeller18@example.com', 'Oakhaven', 'Tidewater Binoculars', 9, 191.08, 'returned', '2026-07-04', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (19, 'ORD-100019', 'Uma Marlowe', 'uma.marlowe19@example.com', 'Port Larkin', 'Summit Tent 2P', 2, 472.71, 'returned', '2026-03-04', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (20, 'ORD-100020', 'Tamsin Brightwater', 'tamsin.brightwater20@example.com', 'Eastvale', 'Trail Lantern', 10, 76.43, 'pending', '2026-06-20', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (21, 'ORD-100021', 'Celia Greystone', 'celia.greystone21@example.com', 'Westmere', 'Cloudlight Hammock', 3, 306.16, 'delivered', '2026-10-12', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (22, 'ORD-100022', 'Darius Delacroix', 'darius.delacroix22@example.com', 'Oakhaven', 'Harbor Rain Jacket', 8, 232.93, 'delivered', '2026-02-05', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (23, 'ORD-100023', 'Ximena Kingsley', 'ximena.kingsley23@example.com', 'Stonebridge', 'Alpine Thermos', 8, 398.62, 'shipped', '2026-09-01', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (24, 'ORD-100024', 'Quinn Lindqvist', 'quinn.lindqvist24@example.com', 'Silverbrook', 'Sunrise Camp Stove', 9, 439.18, 'processing', '2026-05-21', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (25, 'ORD-100025', 'Wren Ivers', 'wren.ivers25@example.com', 'Lakeside Falls', 'Meadow Picnic Set', 3, 173.63, 'shipped', '2026-09-18', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (26, 'ORD-100026', 'Uma Hollins', 'uma.hollins26@example.com', 'Westmere', 'Wildflower Seed Kit', 4, 387.79, 'returned', '2026-12-26', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (27, 'ORD-100027', 'Greta Quill', 'greta.quill27@example.com', 'Harrowgate', 'Meadow Picnic Set', 12, 18.28, 'pending', '2026-05-16', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (28, 'ORD-100028', 'Greta Whitlock', 'greta.whitlock28@example.com', 'Westmere', 'Meadow Picnic Set', 8, 388.97, 'cancelled', '2026-06-12', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (29, 'ORD-100029', 'Hiro Delacroix', 'hiro.delacroix29@example.com', 'Maple Hollow', 'Harbor Rain Jacket', 4, 165.09, 'returned', '2026-10-20', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (30, 'ORD-100030', 'Pavel Underwood', 'pavel.underwood30@example.com', 'Northwick', 'Wildflower Seed Kit', 11, 44.81, 'cancelled', '2026-02-13', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (31, 'ORD-100031', 'Pavel Fairbanks', 'pavel.fairbanks31@example.com', 'Brightmoor', 'Wildflower Seed Kit', 11, 162.61, 'cancelled', '2026-07-15', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (32, 'ORD-100032', 'Ximena Calloway', 'ximena.calloway32@example.com', 'Stonebridge', 'River Kayak Paddle', 3, 476.72, 'pending', '2026-03-19', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (33, 'ORD-100033', 'Zara Underwood', 'zara.underwood33@example.com', 'Silverbrook', 'Pinecrest Sleeping Bag', 10, 470.64, 'cancelled', '2026-06-05', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (34, 'ORD-100034', 'Amara Abernathy', 'amara.abernathy34@example.com', 'Willowmere', 'Sunrise Camp Stove', 11, 53.37, 'cancelled', '2026-03-14', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (35, 'ORD-100035', 'Greta Abernathy', 'greta.abernathy35@example.com', 'Cedar Ridge', 'Summit Tent 2P', 5, 242.8, 'processing', '2026-06-09', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (36, 'ORD-100036', 'Elena Brightwater', 'elena.brightwater36@example.com', 'Fernwood', 'Sunrise Camp Stove', 6, 431.36, 'cancelled', '2026-10-27', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (37, 'ORD-100037', 'Quinn Everhart', 'quinn.everhart37@example.com', 'Lakeside Falls', 'River Kayak Paddle', 9, 247.27, 'returned', '2026-03-20', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (38, 'ORD-100038', 'Yusuf Everhart', 'yusuf.everhart38@example.com', 'Silverbrook', 'River Kayak Paddle', 8, 298.88, 'pending', '2026-09-02', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (39, 'ORD-100039', 'Viktor Quill', 'viktor.quill39@example.com', 'Lakeside Falls', 'Glacier Water Filter', 8, 377.42, 'pending', '2026-09-02', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (40, 'ORD-100040', 'Greta Ivers', 'greta.ivers40@example.com', 'Port Larkin', 'Wildflower Seed Kit', 2, 245.92, 'processing', '2026-01-25', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (41, 'ORD-100041', 'Olivia Kingsley', 'olivia.kingsley41@example.com', 'Westmere', 'Glacier Water Filter', 10, 248.03, 'cancelled', '2026-05-15', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (42, 'ORD-100042', 'Quinn Hollins', 'quinn.hollins42@example.com', 'Stonebridge', 'Glacier Water Filter', 5, 443.28, 'shipped', '2026-08-05', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (43, 'ORD-100043', 'Darius Marlowe', 'darius.marlowe43@example.com', 'Harrowgate', 'Meadow Picnic Set', 2, 323.63, 'returned', '2026-02-07', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (44, 'ORD-100044', 'Zara Delacroix', 'zara.delacroix44@example.com', 'Fernwood', 'Wildflower Seed Kit', 3, 451.23, 'cancelled', '2026-11-12', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (45, 'ORD-100045', 'Ines Everhart', 'ines.everhart45@example.com', 'Harrowgate', 'Summit Tent 2P', 12, 457.42, 'returned', '2026-08-06', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (46, 'ORD-100046', 'Farid Whitlock', 'farid.whitlock46@example.com', 'Brightmoor', 'Glacier Water Filter', 7, 165.75, 'shipped', '2026-06-11', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (47, 'ORD-100047', 'Ximena Lindqvist', 'ximena.lindqvist47@example.com', 'Port Larkin', 'Meadow Picnic Set', 9, 222.6, 'cancelled', '2026-01-13', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (48, 'ORD-100048', 'Quinn Thornbury', 'quinn.thornbury48@example.com', 'Cedar Ridge', 'Glacier Water Filter', 2, 58.16, 'shipped', '2026-02-03', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (49, 'ORD-100049', 'Ines Brightwater', 'ines.brightwater49@example.com', 'Fernwood', 'Wildflower Seed Kit', 3, 133.1, 'shipped', '2026-07-28', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (50, 'ORD-100050', 'Maya Everhart', 'maya.everhart50@example.com', 'Lakeside Falls', 'Lakeshore Folding Chair', 9, 275.82, 'cancelled', '2026-06-03', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (51, 'ORD-100051', 'Bastian Whitlock', 'bastian.whitlock51@example.com', 'Silverbrook', 'Cloudlight Hammock', 2, 132.37, 'pending', '2026-11-03', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (52, 'ORD-100052', 'Celia Thornbury', 'celia.thornbury52@example.com', 'Oakhaven', 'Summit Tent 2P', 2, 130.25, 'pending', '2026-08-01', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (53, 'ORD-100053', 'Rosa Northcott', 'rosa.northcott53@example.com', 'Fernwood', 'Lakeshore Folding Chair', 5, 300.12, 'pending', '2026-09-23', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (54, 'ORD-100054', 'Darius Fairbanks', 'darius.fairbanks54@example.com', 'Cedar Ridge', 'Trail Lantern', 3, 100.44, 'delivered', '2026-11-10', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (55, 'ORD-100055', 'Jonah Okafor', 'jonah.okafor55@example.com', 'Lakeside Falls', 'Tidewater Binoculars', 3, 133.13, 'pending', '2026-05-02', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (56, 'ORD-100056', 'Amara Yarrow', 'amara.yarrow56@example.com', 'Lakeside Falls', 'Glacier Water Filter', 4, 249.02, 'shipped', '2026-08-04', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (57, 'ORD-100057', 'Viktor Pemberton', 'viktor.pemberton57@example.com', 'Lakeside Falls', 'Ridgeline Trekking Poles', 7, 465.88, 'delivered', '2026-12-07', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (58, 'ORD-100058', 'Keira Greystone', 'keira.greystone58@example.com', 'Oakhaven', 'Lakeshore Folding Chair', 12, 351.07, 'shipped', '2026-07-12', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (59, 'ORD-100059', 'Elena Abernathy', 'elena.abernathy59@example.com', 'Eastvale', 'Tidewater Binoculars', 12, 422.87, 'returned', '2026-03-02', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (60, 'ORD-100060', 'Viktor Marlowe', 'viktor.marlowe60@example.com', 'Oakhaven', 'Glacier Water Filter', 11, 466.18, 'processing', '2026-04-23', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (61, 'ORD-100061', 'Bastian Okafor', 'bastian.okafor61@example.com', 'Silverbrook', 'River Kayak Paddle', 5, 216.49, 'delivered', '2026-06-11', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (62, 'ORD-100062', 'Hiro Brightwater', 'hiro.brightwater62@example.com', 'Fernwood', 'Alpine Thermos', 4, 174.06, 'pending', '2026-06-13', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (63, 'ORD-100063', 'Pavel Ivers', 'pavel.ivers63@example.com', 'Lakeside Falls', 'Tidewater Binoculars', 4, 122.51, 'pending', '2026-02-09', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (64, 'ORD-100064', 'Elena Marlowe', 'elena.marlowe64@example.com', 'Westmere', 'Trail Lantern', 7, 15.2, 'delivered', '2026-11-08', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (65, 'ORD-100065', 'Samir Quill', 'samir.quill65@example.com', 'Oakhaven', 'Wildflower Seed Kit', 3, 317.16, 'cancelled', '2026-10-13', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (66, 'ORD-100066', 'Ximena Pemberton', 'ximena.pemberton66@example.com', 'Silverbrook', 'Alpine Thermos', 12, 298.7, 'shipped', '2026-01-27', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (67, 'ORD-100067', 'Ximena Whitlock', 'ximena.whitlock67@example.com', 'Willowmere', 'Glacier Water Filter', 3, 437.15, 'processing', '2026-10-27', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (68, 'ORD-100068', 'Viktor Sterling', 'viktor.sterling68@example.com', 'Willowmere', 'Lakeshore Folding Chair', 12, 329.22, 'cancelled', '2026-11-08', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (69, 'ORD-100069', 'Amara Brightwater', 'amara.brightwater69@example.com', 'Silverbrook', 'Tidewater Binoculars', 6, 460.75, 'returned', '2026-08-18', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (70, 'ORD-100070', 'Uma Abernathy', 'uma.abernathy70@example.com', 'Ravenford', 'Glacier Water Filter', 11, 120.79, 'delivered', '2026-01-15', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (71, 'ORD-100071', 'Ximena Quill', 'ximena.quill71@example.com', 'Fernwood', 'Glacier Water Filter', 2, 318.0, 'pending', '2026-12-24', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (72, 'ORD-100072', 'Ines Calloway', 'ines.calloway72@example.com', 'Oakhaven', 'Alpine Thermos', 4, 351.3, 'shipped', '2026-04-24', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (73, 'ORD-100073', 'Pavel Marlowe', 'pavel.marlowe73@example.com', 'Eastvale', 'Harbor Rain Jacket', 11, 141.12, 'pending', '2026-10-21', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (74, 'ORD-100074', 'Celia Thornbury', 'celia.thornbury74@example.com', 'Silverbrook', 'Meadow Picnic Set', 5, 314.3, 'cancelled', '2026-05-20', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (75, 'ORD-100075', 'Amara Pemberton', 'amara.pemberton75@example.com', 'Port Larkin', 'Harbor Rain Jacket', 5, 466.93, 'pending', '2026-12-07', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (76, 'ORD-100076', 'Jonah Whitlock', 'jonah.whitlock76@example.com', 'Lakeside Falls', 'Alpine Thermos', 8, 226.03, 'pending', '2026-09-07', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (77, 'ORD-100077', 'Celia Pemberton', 'celia.pemberton77@example.com', 'Port Larkin', 'Alpine Thermos', 8, 40.86, 'processing', '2026-08-09', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (78, 'ORD-100078', 'Greta Greystone', 'greta.greystone78@example.com', 'Eastvale', 'Pinecrest Sleeping Bag', 2, 71.9, 'processing', '2026-05-12', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (79, 'ORD-100079', 'Tamsin Underwood', 'tamsin.underwood79@example.com', 'Lakeside Falls', 'Alpine Thermos', 2, 338.94, 'shipped', '2026-08-16', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (80, 'ORD-100080', 'Amara Fairbanks', 'amara.fairbanks80@example.com', 'Port Larkin', 'Harbor Rain Jacket', 11, 218.84, 'delivered', '2026-12-05', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (81, 'ORD-100081', 'Luca Marlowe', 'luca.marlowe81@example.com', 'Northwick', 'Canvas Daypack', 6, 5.33, 'delivered', '2026-07-04', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (82, 'ORD-100082', 'Wren Abernathy', 'wren.abernathy82@example.com', 'Fernwood', 'Sunrise Camp Stove', 5, 124.9, 'pending', '2026-07-13', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (83, 'ORD-100083', 'Luca Northcott', 'luca.northcott83@example.com', 'Willowmere', 'Alpine Thermos', 1, 137.94, 'pending', '2026-11-10', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (84, 'ORD-100084', 'Hiro Ivers', 'hiro.ivers84@example.com', 'Brightmoor', 'Glacier Water Filter', 6, 94.77, 'delivered', '2026-07-01', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (85, 'ORD-100085', 'Rosa Rosales', 'rosa.rosales85@example.com', 'Maple Hollow', 'Sunrise Camp Stove', 2, 28.03, 'cancelled', '2026-07-15', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (86, 'ORD-100086', 'Uma Jareth', 'uma.jareth86@example.com', 'Harrowgate', 'Trail Lantern', 9, 65.04, 'returned', '2026-07-11', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (87, 'ORD-100087', 'Jonah Ivers', 'jonah.ivers87@example.com', 'Stonebridge', 'Sunrise Camp Stove', 11, 128.21, 'cancelled', '2026-04-10', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (88, 'ORD-100088', 'Rosa Valdez', 'rosa.valdez88@example.com', 'Brightmoor', 'Canvas Daypack', 3, 310.34, 'pending', '2026-04-17', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (89, 'ORD-100089', 'Rosa Hollins', 'rosa.hollins89@example.com', 'Harrowgate', 'Lakeshore Folding Chair', 6, 478.32, 'returned', '2026-07-05', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (90, 'ORD-100090', 'Hiro Calloway', 'hiro.calloway90@example.com', 'Silverbrook', 'Meadow Picnic Set', 9, 47.82, 'shipped', '2026-06-09', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (91, 'ORD-100091', 'Amara Yarrow', 'amara.yarrow91@example.com', 'Oakhaven', 'Cloudlight Hammock', 7, 201.3, 'processing', '2026-04-13', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (92, 'ORD-100092', 'Keira Zeller', 'keira.zeller92@example.com', 'Port Larkin', 'Harbor Rain Jacket', 5, 277.57, 'delivered', '2026-03-22', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (93, 'ORD-100093', 'Celia Ivers', 'celia.ivers93@example.com', 'Fernwood', 'Summit Tent 2P', 7, 194.58, 'returned', '2026-07-10', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (94, 'ORD-100094', 'Elena Brightwater', 'elena.brightwater94@example.com', 'Brightmoor', 'Sunrise Camp Stove', 8, 464.92, 'returned', '2026-01-03', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (95, 'ORD-100095', 'Quinn Okafor', 'quinn.okafor95@example.com', 'Harrowgate', 'Summit Tent 2P', 2, 110.92, 'shipped', '2026-09-22', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (96, 'ORD-100096', 'Ximena Whitlock', 'ximena.whitlock96@example.com', 'Ravenford', 'Ridgeline Trekking Poles', 8, 44.92, 'pending', '2026-01-26', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (97, 'ORD-100097', 'Hiro Sterling', 'hiro.sterling0@example.com', 'Fernwood', 'Trail Lantern', 11, 344.49, 'shipped', '2026-11-09', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (98, 'ORD-100098', 'Wren Zeller', 'wren.zeller1@example.com', 'Eastvale', 'Canvas Daypack', 2, 147.32, 'processing', '2026-04-13', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (99, 'ORD-100099', 'Hiro Thornbury', 'hiro.thornbury2@example.com', 'Port Larkin', 'Trail Lantern', 9, 147.87, 'returned', '2026-05-11', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (100, 'ORD-100100', 'Pavel Quill', 'pavel.quill3@example.com', 'Maple Hollow', 'Glacier Water Filter', 4, 18.42, 'returned', '2026-12-21', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (101, 'ORD-100101', 'Bastian Abernathy', 'bastian.abernathy4@example.com', 'Maple Hollow', 'Harbor Rain Jacket', 11, 312.23, 'pending', '2026-05-08', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (102, 'ORD-100102', 'Luca Hollins', 'luca.hollins5@example.com', 'Harrowgate', 'Trail Lantern', 12, 165.24, 'returned', '2026-06-22', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (103, 'ORD-100103', 'Greta Abernathy', 'greta.abernathy6@example.com', 'Willowmere', 'Alpine Thermos', 12, 406.37, 'pending', '2026-04-16', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (104, 'ORD-100104', 'Jonah Zeller', 'jonah.zeller7@example.com', 'Oakhaven', 'Summit Tent 2P', 4, 225.66, 'delivered', '2026-05-04', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (105, 'ORD-100105', 'Tamsin Fairbanks', 'tamsin.fairbanks8@example.com', 'Fernwood', 'Summit Tent 2P', 8, 202.8, 'cancelled', '2026-01-20', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (106, 'ORD-100106', 'Maya Brightwater', 'maya.brightwater9@example.com', 'Maple Hollow', 'Trail Lantern', 10, 71.98, 'pending', '2026-12-02', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (107, 'ORD-100107', 'Maya Okafor', 'maya.okafor10@example.com', 'Fernwood', 'Sunrise Camp Stove', 6, 352.91, 'pending', '2026-03-11', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (108, 'ORD-100108', 'Farid Underwood', 'farid.underwood11@example.com', 'Fernwood', 'Glacier Water Filter', 12, 226.85, 'delivered', '2026-11-24', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (109, 'ORD-100109', 'Luca Kingsley', 'luca.kingsley12@example.com', 'Harrowgate', 'River Kayak Paddle', 2, 5.87, 'delivered', '2026-02-12', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (110, 'ORD-100110', 'Darius Rosales', 'darius.rosales13@example.com', 'Willowmere', 'Summit Tent 2P', 7, 174.08, 'delivered', '2026-07-03', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (111, 'ORD-100111', 'Wren Pemberton', 'wren.pemberton14@example.com', 'Maple Hollow', 'Meadow Picnic Set', 9, 441.73, 'shipped', '2026-06-12', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (112, 'ORD-100112', 'Amara Underwood', 'amara.underwood15@example.com', 'Brightmoor', 'Summit Tent 2P', 11, 369.05, 'pending', '2026-07-02', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (113, 'ORD-100113', 'Celia Brightwater', 'celia.brightwater16@example.com', 'Cedar Ridge', 'Summit Tent 2P', 12, 34.39, 'processing', '2026-06-12', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (114, 'ORD-100114', 'Keira Thornbury', 'keira.thornbury17@example.com', 'Port Larkin', 'Alpine Thermos', 12, 345.26, 'delivered', '2026-05-10', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (115, 'ORD-100115', 'Ximena Zeller', 'ximena.zeller18@example.com', 'Westmere', 'Lakeshore Folding Chair', 11, 454.55, 'pending', '2026-01-27', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (116, 'ORD-100116', 'Darius Pemberton', 'darius.pemberton19@example.com', 'Stonebridge', 'Harbor Rain Jacket', 7, 380.05, 'returned', '2026-08-05', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (117, 'ORD-100117', 'Farid Abernathy', 'farid.abernathy20@example.com', 'Willowmere', 'Lakeshore Folding Chair', 12, 148.73, 'cancelled', '2026-03-20', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (118, 'ORD-100118', 'Keira Kingsley', 'keira.kingsley21@example.com', 'Harrowgate', 'Meadow Picnic Set', 10, 42.07, 'shipped', '2026-07-25', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (119, 'ORD-100119', 'Hiro Northcott', 'hiro.northcott22@example.com', 'Eastvale', 'Tidewater Binoculars', 1, 233.54, 'processing', '2026-06-06', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (120, 'ORD-100120', 'Darius Calloway', 'darius.calloway23@example.com', 'Cedar Ridge', 'Pinecrest Sleeping Bag', 2, 103.57, 'returned', '2026-08-23', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (121, 'ORD-100121', 'Farid Hollins', 'farid.hollins24@example.com', 'Silverbrook', 'Cloudlight Hammock', 8, 299.46, 'cancelled', '2026-04-24', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (122, 'ORD-100122', 'Yusuf Jareth', 'yusuf.jareth25@example.com', 'Cedar Ridge', 'Alpine Thermos', 10, 131.78, 'delivered', '2026-12-09', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (123, 'ORD-100123', 'Olivia Hollins', 'olivia.hollins26@example.com', 'Silverbrook', 'Summit Tent 2P', 4, 77.4, 'processing', '2026-04-11', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (124, 'ORD-100124', 'Maya Ivers', 'maya.ivers27@example.com', 'Maple Hollow', 'Glacier Water Filter', 9, 114.52, 'pending', '2026-11-15', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (125, 'ORD-100125', 'Darius Abernathy', 'darius.abernathy28@example.com', 'Harrowgate', 'Lakeshore Folding Chair', 4, 404.18, 'delivered', '2026-01-10', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (126, 'ORD-100126', 'Darius Brightwater', 'darius.brightwater29@example.com', 'Maple Hollow', 'Pinecrest Sleeping Bag', 10, 96.82, 'pending', '2026-06-17', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (127, 'ORD-100127', 'Olivia Thornbury', 'olivia.thornbury30@example.com', 'Cedar Ridge', 'Wildflower Seed Kit', 11, 454.18, 'pending', '2026-11-20', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (128, 'ORD-100128', 'Greta Brightwater', 'greta.brightwater31@example.com', 'Northwick', 'Meadow Picnic Set', 3, 25.5, 'delivered', '2026-01-20', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (129, 'ORD-100129', 'Amara Kingsley', 'amara.kingsley32@example.com', 'Brightmoor', 'Tidewater Binoculars', 6, 92.54, 'delivered', '2026-02-07', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (130, 'ORD-100130', 'Zara Pemberton', 'zara.pemberton33@example.com', 'Lakeside Falls', 'Harbor Rain Jacket', 2, 198.58, 'returned', '2026-11-18', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (131, 'ORD-100131', 'Uma Rosales', 'uma.rosales34@example.com', 'Eastvale', 'Tidewater Binoculars', 3, 193.64, 'delivered', '2026-07-10', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (132, 'ORD-100132', 'Nikolai Brightwater', 'nikolai.brightwater35@example.com', 'Cedar Ridge', 'Sunrise Camp Stove', 10, 424.7, 'returned', '2026-07-01', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (133, 'ORD-100133', 'Uma Greystone', 'uma.greystone36@example.com', 'Brightmoor', 'Sunrise Camp Stove', 7, 101.34, 'pending', '2026-07-06', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (134, 'ORD-100134', 'Darius Calloway', 'darius.calloway37@example.com', 'Brightmoor', 'Pinecrest Sleeping Bag', 6, 223.66, 'shipped', '2026-03-01', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (135, 'ORD-100135', 'Rosa Everhart', 'rosa.everhart38@example.com', 'Ravenford', 'Wildflower Seed Kit', 7, 46.83, 'processing', '2026-06-24', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (136, 'ORD-100136', 'Elena Lindqvist', 'elena.lindqvist39@example.com', 'Cedar Ridge', 'River Kayak Paddle', 9, 86.18, 'pending', '2026-02-13', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (137, 'ORD-100137', 'Yusuf Greystone', 'yusuf.greystone40@example.com', 'Cedar Ridge', 'River Kayak Paddle', 1, 468.37, 'returned', '2026-06-02', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (138, 'ORD-100138', 'Celia Whitlock', 'celia.whitlock41@example.com', 'Westmere', 'Sunrise Camp Stove', 3, 308.97, 'shipped', '2026-10-13', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (139, 'ORD-100139', 'Pavel Fairbanks', 'pavel.fairbanks42@example.com', 'Westmere', 'Summit Tent 2P', 1, 194.58, 'processing', '2026-03-13', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (140, 'ORD-100140', 'Darius Everhart', 'darius.everhart43@example.com', 'Maple Hollow', 'Sunrise Camp Stove', 4, 24.04, 'processing', '2026-11-02', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (141, 'ORD-100141', 'Darius Marlowe', 'darius.marlowe44@example.com', 'Westmere', 'Harbor Rain Jacket', 9, 408.2, 'delivered', '2026-11-14', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (142, 'ORD-100142', 'Samir Hollins', 'samir.hollins45@example.com', 'Brightmoor', 'Cloudlight Hammock', 11, 179.22, 'processing', '2026-08-06', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (143, 'ORD-100143', 'Amara Thornbury', 'amara.thornbury46@example.com', 'Harrowgate', 'Harbor Rain Jacket', 4, 216.96, 'processing', '2026-08-27', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (144, 'ORD-100144', 'Zara Pemberton', 'zara.pemberton47@example.com', 'Brightmoor', 'Canvas Daypack', 2, 65.58, 'returned', '2026-06-03', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (145, 'ORD-100145', 'Quinn Quill', 'quinn.quill48@example.com', 'Ravenford', 'Trail Lantern', 1, 307.13, 'pending', '2026-12-11', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (146, 'ORD-100146', 'Bastian Zeller', 'bastian.zeller49@example.com', 'Lakeside Falls', 'Lakeshore Folding Chair', 7, 314.88, 'shipped', '2026-01-28', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (147, 'ORD-100147', 'Tamsin Yarrow', 'tamsin.yarrow50@example.com', 'Stonebridge', 'Ridgeline Trekking Poles', 2, 96.61, 'returned', '2026-05-26', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (148, 'ORD-100148', 'Viktor Yarrow', 'viktor.yarrow51@example.com', 'Fernwood', 'Summit Tent 2P', 2, 400.61, 'processing', '2026-05-06', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (149, 'ORD-100149', 'Tamsin Ivers', 'tamsin.ivers52@example.com', 'Fernwood', 'Ridgeline Trekking Poles', 8, 72.77, 'processing', '2026-08-07', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (150, 'ORD-100150', 'Tamsin Quill', 'tamsin.quill53@example.com', 'Maple Hollow', 'Meadow Picnic Set', 6, 22.01, 'shipped', '2026-07-06', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (151, 'ORD-100151', 'Viktor Kingsley', 'viktor.kingsley54@example.com', 'Fernwood', 'Cloudlight Hammock', 3, 381.16, 'delivered', '2026-02-25', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (152, 'ORD-100152', 'Uma Lindqvist', 'uma.lindqvist55@example.com', 'Oakhaven', 'Harbor Rain Jacket', 9, 252.45, 'cancelled', '2026-02-09', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (153, 'ORD-100153', 'Ximena Lindqvist', 'ximena.lindqvist56@example.com', 'Cedar Ridge', 'Cloudlight Hammock', 6, 279.03, 'delivered', '2026-06-25', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (154, 'ORD-100154', 'Olivia Hollins', 'olivia.hollins57@example.com', 'Silverbrook', 'Pinecrest Sleeping Bag', 12, 460.02, 'delivered', '2026-09-09', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (155, 'ORD-100155', 'Uma Sterling', 'uma.sterling58@example.com', 'Fernwood', 'Tidewater Binoculars', 6, 353.06, 'cancelled', '2026-01-08', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (156, 'ORD-100156', 'Jonah Thornbury', 'jonah.thornbury59@example.com', 'Ravenford', 'Cloudlight Hammock', 7, 248.28, 'pending', '2026-03-16', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (157, 'ORD-100157', 'Tamsin Underwood', 'tamsin.underwood60@example.com', 'Port Larkin', 'Trail Lantern', 1, 5.74, 'delivered', '2026-05-04', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (158, 'ORD-100158', 'Rosa Hollins', 'rosa.hollins61@example.com', 'Brightmoor', 'Pinecrest Sleeping Bag', 5, 284.61, 'shipped', '2026-06-20', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (159, 'ORD-100159', 'Farid Everhart', 'farid.everhart62@example.com', 'Port Larkin', 'Lakeshore Folding Chair', 4, 340.9, 'returned', '2026-02-03', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (160, 'ORD-100160', 'Viktor Ivers', 'viktor.ivers63@example.com', 'Brightmoor', 'Wildflower Seed Kit', 5, 464.37, 'pending', '2026-11-27', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (161, 'ORD-100161', 'Tamsin Underwood', 'tamsin.underwood64@example.com', 'Westmere', 'Harbor Rain Jacket', 10, 450.12, 'cancelled', '2026-08-08', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (162, 'ORD-100162', 'Amara Brightwater', 'amara.brightwater65@example.com', 'Port Larkin', 'Glacier Water Filter', 1, 197.55, 'shipped', '2026-03-02', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (163, 'ORD-100163', 'Amara Thornbury', 'amara.thornbury66@example.com', 'Lakeside Falls', 'Tidewater Binoculars', 4, 72.15, 'shipped', '2026-09-20', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (164, 'ORD-100164', 'Tamsin Fairbanks', 'tamsin.fairbanks67@example.com', 'Lakeside Falls', 'Alpine Thermos', 2, 147.28, 'pending', '2026-12-26', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (165, 'ORD-100165', 'Wren Rosales', 'wren.rosales68@example.com', 'Port Larkin', 'Cloudlight Hammock', 7, 358.84, 'returned', '2026-02-24', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (166, 'ORD-100166', 'Farid Hollins', 'farid.hollins69@example.com', 'Eastvale', 'Alpine Thermos', 4, 310.73, 'pending', '2026-06-24', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (167, 'ORD-100167', 'Wren Brightwater', 'wren.brightwater70@example.com', 'Cedar Ridge', 'Tidewater Binoculars', 9, 327.48, 'cancelled', '2026-09-09', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (168, 'ORD-100168', 'Uma Greystone', 'uma.greystone71@example.com', 'Eastvale', 'Lakeshore Folding Chair', 9, 11.74, 'delivered', '2026-04-27', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (169, 'ORD-100169', 'Farid Yarrow', 'farid.yarrow72@example.com', 'Fernwood', 'Meadow Picnic Set', 4, 423.02, 'delivered', '2026-10-08', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (170, 'ORD-100170', 'Uma Whitlock', 'uma.whitlock73@example.com', 'Ravenford', 'Ridgeline Trekking Poles', 9, 227.74, 'processing', '2026-12-01', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (171, 'ORD-100171', 'Nikolai Yarrow', 'nikolai.yarrow74@example.com', 'Maple Hollow', 'Pinecrest Sleeping Bag', 5, 379.77, 'returned', '2026-10-19', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (172, 'ORD-100172', 'Samir Fairbanks', 'samir.fairbanks75@example.com', 'Silverbrook', 'Trail Lantern', 1, 57.71, 'processing', '2026-03-12', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (173, 'ORD-100173', 'Wren Abernathy', 'wren.abernathy76@example.com', 'Port Larkin', 'Trail Lantern', 3, 333.84, 'cancelled', '2026-01-23', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (174, 'ORD-100174', 'Ximena Brightwater', 'ximena.brightwater77@example.com', 'Eastvale', 'Ridgeline Trekking Poles', 10, 366.72, 'shipped', '2026-09-22', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (175, 'ORD-100175', 'Yusuf Whitlock', 'yusuf.whitlock78@example.com', 'Brightmoor', 'Canvas Daypack', 4, 102.32, 'pending', '2026-01-02', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (176, 'ORD-100176', 'Yusuf Underwood', 'yusuf.underwood79@example.com', 'Ravenford', 'Alpine Thermos', 8, 51.99, 'pending', '2026-11-07', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (177, 'ORD-100177', 'Keira Kingsley', 'keira.kingsley80@example.com', 'Brightmoor', 'Alpine Thermos', 1, 171.35, 'delivered', '2026-01-23', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (178, 'ORD-100178', 'Keira Zeller', 'keira.zeller81@example.com', 'Westmere', 'Glacier Water Filter', 8, 409.33, 'processing', '2026-12-01', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (179, 'ORD-100179', 'Amara Northcott', 'amara.northcott82@example.com', 'Lakeside Falls', 'Wildflower Seed Kit', 2, 169.39, 'cancelled', '2026-01-18', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (180, 'ORD-100180', 'Wren Calloway', 'wren.calloway83@example.com', 'Westmere', 'Ridgeline Trekking Poles', 5, 85.51, 'pending', '2026-09-07', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (181, 'ORD-100181', 'Yusuf Zeller', 'yusuf.zeller84@example.com', 'Port Larkin', 'Trail Lantern', 6, 237.89, 'returned', '2026-12-26', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (182, 'ORD-100182', 'Pavel Sterling', 'pavel.sterling85@example.com', 'Northwick', 'Ridgeline Trekking Poles', 9, 128.4, 'shipped', '2026-05-27', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (183, 'ORD-100183', 'Wren Hollins', 'wren.hollins86@example.com', 'Harrowgate', 'River Kayak Paddle', 2, 450.86, 'pending', '2026-08-26', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (184, 'ORD-100184', 'Uma Kingsley', 'uma.kingsley87@example.com', 'Northwick', 'Canvas Daypack', 7, 446.0, 'cancelled', '2026-02-14', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (185, 'ORD-100185', 'Luca Greystone', 'luca.greystone88@example.com', 'Cedar Ridge', 'Alpine Thermos', 7, 433.03, 'processing', '2026-03-13', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (186, 'ORD-100186', 'Olivia Everhart', 'olivia.everhart89@example.com', 'Lakeside Falls', 'Pinecrest Sleeping Bag', 12, 362.55, 'cancelled', '2026-01-12', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (187, 'ORD-100187', 'Quinn Everhart', 'quinn.everhart90@example.com', 'Oakhaven', 'Ridgeline Trekking Poles', 8, 319.33, 'cancelled', '2026-06-06', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (188, 'ORD-100188', 'Olivia Whitlock', 'olivia.whitlock91@example.com', 'Willowmere', 'Alpine Thermos', 10, 114.35, 'delivered', '2026-08-21', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (189, 'ORD-100189', 'Quinn Greystone', 'quinn.greystone92@example.com', 'Cedar Ridge', 'Alpine Thermos', 12, 397.51, 'processing', '2026-03-24', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (190, 'ORD-100190', 'Hiro Yarrow', 'hiro.yarrow93@example.com', 'Northwick', 'Pinecrest Sleeping Bag', 9, 170.27, 'shipped', '2026-06-07', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (191, 'ORD-100191', 'Ximena Delacroix', 'ximena.delacroix94@example.com', 'Silverbrook', 'Tidewater Binoculars', 2, 97.43, 'shipped', '2026-03-26', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (192, 'ORD-100192', 'Ximena Jareth', 'ximena.jareth95@example.com', 'Brightmoor', 'Alpine Thermos', 4, 56.46, 'pending', '2026-05-07', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (193, 'ORD-100193', 'Olivia Brightwater', 'olivia.brightwater96@example.com', 'Port Larkin', 'Cloudlight Hammock', 7, 334.23, 'processing', '2026-11-10', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (194, 'ORD-100194', 'Amara Everhart', 'amara.everhart0@example.com', 'Cedar Ridge', 'Pinecrest Sleeping Bag', 12, 196.94, 'cancelled', '2026-04-28', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (195, 'ORD-100195', 'Wren Sterling', 'wren.sterling1@example.com', 'Westmere', 'Sunrise Camp Stove', 11, 204.76, 'shipped', '2026-11-24', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (196, 'ORD-100196', 'Viktor Fairbanks', 'viktor.fairbanks2@example.com', 'Ravenford', 'Canvas Daypack', 8, 210.17, 'delivered', '2026-11-23', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (197, 'ORD-100197', 'Nikolai Hollins', 'nikolai.hollins3@example.com', 'Willowmere', 'Cloudlight Hammock', 12, 343.36, 'shipped', '2026-05-28', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (198, 'ORD-100198', 'Pavel Okafor', 'pavel.okafor4@example.com', 'Port Larkin', 'Pinecrest Sleeping Bag', 7, 250.93, 'cancelled', '2026-03-21', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (199, 'ORD-100199', 'Yusuf Abernathy', 'yusuf.abernathy5@example.com', 'Brightmoor', 'Ridgeline Trekking Poles', 8, 436.35, 'pending', '2026-01-09', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (200, 'ORD-100200', 'Farid Whitlock', 'farid.whitlock6@example.com', 'Willowmere', 'Summit Tent 2P', 9, 170.07, 'processing', '2026-08-18', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (201, 'ORD-100201', 'Wren Pemberton', 'wren.pemberton7@example.com', 'Lakeside Falls', 'Trail Lantern', 11, 381.37, 'delivered', '2026-09-11', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (202, 'ORD-100202', 'Ximena Okafor', 'ximena.okafor8@example.com', 'Maple Hollow', 'Tidewater Binoculars', 3, 191.13, 'pending', '2026-12-20', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (203, 'ORD-100203', 'Uma Brightwater', 'uma.brightwater9@example.com', 'Cedar Ridge', 'Alpine Thermos', 7, 194.55, 'pending', '2026-02-14', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (204, 'ORD-100204', 'Uma Whitlock', 'uma.whitlock10@example.com', 'Ravenford', 'Meadow Picnic Set', 10, 130.58, 'shipped', '2026-05-24', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (205, 'ORD-100205', 'Quinn Hollins', 'quinn.hollins11@example.com', 'Willowmere', 'Cloudlight Hammock', 8, 105.31, 'shipped', '2026-02-26', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (206, 'ORD-100206', 'Pavel Underwood', 'pavel.underwood12@example.com', 'Lakeside Falls', 'Sunrise Camp Stove', 4, 391.86, 'shipped', '2026-06-22', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (207, 'ORD-100207', 'Olivia Jareth', 'olivia.jareth13@example.com', 'Willowmere', 'Glacier Water Filter', 11, 64.02, 'returned', '2026-06-26', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (208, 'ORD-100208', 'Ines Whitlock', 'ines.whitlock14@example.com', 'Brightmoor', 'Tidewater Binoculars', 5, 471.86, 'cancelled', '2026-03-16', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (209, 'ORD-100209', 'Zara Yarrow', 'zara.yarrow15@example.com', 'Willowmere', 'Alpine Thermos', 6, 120.98, 'delivered', '2026-06-16', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (210, 'ORD-100210', 'Nikolai Thornbury', 'nikolai.thornbury16@example.com', 'Ravenford', 'Canvas Daypack', 11, 431.03, 'shipped', '2026-05-28', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (211, 'ORD-100211', 'Bastian Calloway', 'bastian.calloway17@example.com', 'Oakhaven', 'Pinecrest Sleeping Bag', 6, 377.31, 'shipped', '2026-09-27', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (212, 'ORD-100212', 'Uma Sterling', 'uma.sterling18@example.com', 'Port Larkin', 'Tidewater Binoculars', 1, 104.24, 'pending', '2026-11-10', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (213, 'ORD-100213', 'Tamsin Delacroix', 'tamsin.delacroix19@example.com', 'Westmere', 'River Kayak Paddle', 4, 92.78, 'returned', '2026-06-26', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (214, 'ORD-100214', 'Greta Marlowe', 'greta.marlowe20@example.com', 'Willowmere', 'Glacier Water Filter', 3, 294.32, 'cancelled', '2026-10-26', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (215, 'ORD-100215', 'Viktor Rosales', 'viktor.rosales21@example.com', 'Willowmere', 'Tidewater Binoculars', 5, 98.35, 'cancelled', '2026-04-17', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (216, 'ORD-100216', 'Ximena Okafor', 'ximena.okafor22@example.com', 'Ravenford', 'Lakeshore Folding Chair', 2, 268.43, 'delivered', '2026-07-08', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (217, 'ORD-100217', 'Pavel Pemberton', 'pavel.pemberton23@example.com', 'Lakeside Falls', 'Trail Lantern', 8, 226.6, 'shipped', '2026-12-16', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (218, 'ORD-100218', 'Pavel Fairbanks', 'pavel.fairbanks24@example.com', 'Lakeside Falls', 'Pinecrest Sleeping Bag', 12, 7.64, 'delivered', '2026-08-23', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (219, 'ORD-100219', 'Viktor Jareth', 'viktor.jareth25@example.com', 'Oakhaven', 'Harbor Rain Jacket', 6, 206.97, 'cancelled', '2026-02-06', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (220, 'ORD-100220', 'Uma Underwood', 'uma.underwood26@example.com', 'Port Larkin', 'Trail Lantern', 10, 26.31, 'cancelled', '2026-06-26', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (221, 'ORD-100221', 'Quinn Pemberton', 'quinn.pemberton27@example.com', 'Harrowgate', 'Wildflower Seed Kit', 3, 20.62, 'cancelled', '2026-07-21', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (222, 'ORD-100222', 'Keira Delacroix', 'keira.delacroix28@example.com', 'Oakhaven', 'Tidewater Binoculars', 6, 166.79, 'processing', '2026-09-25', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (223, 'ORD-100223', 'Jonah Northcott', 'jonah.northcott29@example.com', 'Northwick', 'Cloudlight Hammock', 5, 267.94, 'delivered', '2026-05-12', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (224, 'ORD-100224', 'Maya Kingsley', 'maya.kingsley30@example.com', 'Lakeside Falls', 'Alpine Thermos', 9, 168.46, 'shipped', '2026-11-16', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (225, 'ORD-100225', 'Keira Greystone', 'keira.greystone31@example.com', 'Northwick', 'Sunrise Camp Stove', 5, 65.16, 'cancelled', '2026-02-26', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (226, 'ORD-100226', 'Maya Yarrow', 'maya.yarrow32@example.com', 'Lakeside Falls', 'Lakeshore Folding Chair', 7, 263.84, 'pending', '2026-07-10', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (227, 'ORD-100227', 'Amara Brightwater', 'amara.brightwater33@example.com', 'Maple Hollow', 'Ridgeline Trekking Poles', 8, 293.93, 'cancelled', '2026-01-26', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (228, 'ORD-100228', 'Tamsin Everhart', 'tamsin.everhart34@example.com', 'Ravenford', 'Tidewater Binoculars', 12, 332.18, 'cancelled', '2026-02-07', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (229, 'ORD-100229', 'Viktor Underwood', 'viktor.underwood35@example.com', 'Harrowgate', 'Tidewater Binoculars', 3, 52.7, 'shipped', '2026-01-14', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (230, 'ORD-100230', 'Uma Abernathy', 'uma.abernathy36@example.com', 'Northwick', 'Ridgeline Trekking Poles', 3, 378.5, 'processing', '2026-12-09', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (231, 'ORD-100231', 'Farid Northcott', 'farid.northcott37@example.com', 'Port Larkin', 'Meadow Picnic Set', 1, 209.29, 'cancelled', '2026-10-02', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (232, 'ORD-100232', 'Samir Quill', 'samir.quill38@example.com', 'Port Larkin', 'Ridgeline Trekking Poles', 2, 372.43, 'returned', '2026-10-23', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (233, 'ORD-100233', 'Olivia Calloway', 'olivia.calloway39@example.com', 'Port Larkin', 'Tidewater Binoculars', 7, 286.88, 'cancelled', '2026-03-16', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (234, 'ORD-100234', 'Rosa Delacroix', 'rosa.delacroix40@example.com', 'Eastvale', 'Tidewater Binoculars', 8, 105.44, 'shipped', '2026-11-01', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (235, 'ORD-100235', 'Amara Abernathy', 'amara.abernathy41@example.com', 'Ravenford', 'Tidewater Binoculars', 2, 473.65, 'pending', '2026-04-28', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (236, 'ORD-100236', 'Elena Pemberton', 'elena.pemberton42@example.com', 'Port Larkin', 'Alpine Thermos', 12, 275.05, 'returned', '2026-12-24', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (237, 'ORD-100237', 'Bastian Lindqvist', 'bastian.lindqvist43@example.com', 'Willowmere', 'Sunrise Camp Stove', 12, 334.9, 'shipped', '2026-12-25', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (238, 'ORD-100238', 'Jonah Underwood', 'jonah.underwood44@example.com', 'Lakeside Falls', 'Sunrise Camp Stove', 8, 223.51, 'delivered', '2026-01-23', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (239, 'ORD-100239', 'Amara Brightwater', 'amara.brightwater45@example.com', 'Port Larkin', 'Lakeshore Folding Chair', 11, 331.0, 'processing', '2026-02-13', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (240, 'ORD-100240', 'Jonah Yarrow', 'jonah.yarrow46@example.com', 'Westmere', 'River Kayak Paddle', 8, 294.05, 'delivered', '2026-06-19', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (241, 'ORD-100241', 'Pavel Valdez', 'pavel.valdez47@example.com', 'Silverbrook', 'River Kayak Paddle', 2, 177.23, 'cancelled', '2026-03-21', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (242, 'ORD-100242', 'Pavel Marlowe', 'pavel.marlowe48@example.com', 'Willowmere', 'Wildflower Seed Kit', 8, 453.81, 'processing', '2026-06-10', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (243, 'ORD-100243', 'Bastian Thornbury', 'bastian.thornbury49@example.com', 'Ravenford', 'Sunrise Camp Stove', 10, 162.39, 'processing', '2026-12-01', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (244, 'ORD-100244', 'Tamsin Jareth', 'tamsin.jareth50@example.com', 'Westmere', 'Cloudlight Hammock', 4, 183.61, 'cancelled', '2026-07-20', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (245, 'ORD-100245', 'Zara Okafor', 'zara.okafor51@example.com', 'Cedar Ridge', 'Sunrise Camp Stove', 1, 157.39, 'delivered', '2026-07-06', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (246, 'ORD-100246', 'Jonah Everhart', 'jonah.everhart52@example.com', 'Willowmere', 'Lakeshore Folding Chair', 10, 74.4, 'processing', '2026-11-25', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (247, 'ORD-100247', 'Luca Rosales', 'luca.rosales53@example.com', 'Eastvale', 'Glacier Water Filter', 9, 235.0, 'returned', '2026-04-26', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (248, 'ORD-100248', 'Jonah Thornbury', 'jonah.thornbury54@example.com', 'Port Larkin', 'Tidewater Binoculars', 7, 225.76, 'shipped', '2026-05-19', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (249, 'ORD-100249', 'Zara Marlowe', 'zara.marlowe55@example.com', 'Harrowgate', 'Glacier Water Filter', 2, 259.44, 'delivered', '2026-02-08', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (250, 'ORD-100250', 'Samir Quill', 'samir.quill56@example.com', 'Fernwood', 'Alpine Thermos', 9, 157.13, 'processing', '2026-10-07', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (251, 'ORD-100251', 'Greta Greystone', 'greta.greystone57@example.com', 'Eastvale', 'River Kayak Paddle', 12, 142.3, 'processing', '2026-10-12', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (252, 'ORD-100252', 'Yusuf Quill', 'yusuf.quill58@example.com', 'Oakhaven', 'River Kayak Paddle', 4, 25.7, 'returned', '2026-06-28', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (253, 'ORD-100253', 'Luca Underwood', 'luca.underwood59@example.com', 'Harrowgate', 'Wildflower Seed Kit', 2, 78.75, 'processing', '2026-01-12', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (254, 'ORD-100254', 'Quinn Thornbury', 'quinn.thornbury60@example.com', 'Port Larkin', 'Canvas Daypack', 1, 101.81, 'processing', '2026-08-19', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (255, 'ORD-100255', 'Ines Zeller', 'ines.zeller61@example.com', 'Cedar Ridge', 'Cloudlight Hammock', 2, 454.56, 'processing', '2026-10-05', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (256, 'ORD-100256', 'Bastian Kingsley', 'bastian.kingsley62@example.com', 'Maple Hollow', 'River Kayak Paddle', 7, 44.28, 'pending', '2026-01-18', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (257, 'ORD-100257', 'Wren Okafor', 'wren.okafor63@example.com', 'Harrowgate', 'Ridgeline Trekking Poles', 2, 414.84, 'cancelled', '2026-07-04', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (258, 'ORD-100258', 'Ines Kingsley', 'ines.kingsley64@example.com', 'Westmere', 'Summit Tent 2P', 11, 47.19, 'cancelled', '2026-09-13', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (259, 'ORD-100259', 'Olivia Fairbanks', 'olivia.fairbanks65@example.com', 'Northwick', 'Summit Tent 2P', 12, 109.93, 'pending', '2026-05-12', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (260, 'ORD-100260', 'Rosa Abernathy', 'rosa.abernathy66@example.com', 'Oakhaven', 'Lakeshore Folding Chair', 1, 127.13, 'processing', '2026-12-24', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (261, 'ORD-100261', 'Bastian Delacroix', 'bastian.delacroix67@example.com', 'Silverbrook', 'Meadow Picnic Set', 1, 451.18, 'cancelled', '2026-12-10', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (262, 'ORD-100262', 'Yusuf Underwood', 'yusuf.underwood68@example.com', 'Eastvale', 'Harbor Rain Jacket', 6, 181.24, 'returned', '2026-02-12', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (263, 'ORD-100263', 'Maya Fairbanks', 'maya.fairbanks69@example.com', 'Harrowgate', 'Summit Tent 2P', 3, 439.25, 'pending', '2026-08-23', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (264, 'ORD-100264', 'Zara Brightwater', 'zara.brightwater70@example.com', 'Silverbrook', 'Lakeshore Folding Chair', 4, 41.49, 'processing', '2026-06-24', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (265, 'ORD-100265', 'Yusuf Okafor', 'yusuf.okafor71@example.com', 'Eastvale', 'Lakeshore Folding Chair', 7, 404.99, 'cancelled', '2026-02-15', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (266, 'ORD-100266', 'Keira Hollins', 'keira.hollins72@example.com', 'Harrowgate', 'Canvas Daypack', 11, 178.55, 'delivered', '2026-04-24', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (267, 'ORD-100267', 'Farid Whitlock', 'farid.whitlock73@example.com', 'Harrowgate', 'Glacier Water Filter', 3, 213.23, 'shipped', '2026-05-14', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (268, 'ORD-100268', 'Hiro Everhart', 'hiro.everhart74@example.com', 'Port Larkin', 'Alpine Thermos', 10, 403.71, 'delivered', '2026-03-09', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (269, 'ORD-100269', 'Darius Kingsley', 'darius.kingsley75@example.com', 'Harrowgate', 'Lakeshore Folding Chair', 8, 58.79, 'processing', '2026-01-21', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (270, 'ORD-100270', 'Rosa Pemberton', 'rosa.pemberton76@example.com', 'Oakhaven', 'Alpine Thermos', 2, 127.08, 'shipped', '2026-06-14', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (271, 'ORD-100271', 'Hiro Hollins', 'hiro.hollins77@example.com', 'Eastvale', 'Cloudlight Hammock', 5, 202.13, 'shipped', '2026-01-27', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (272, 'ORD-100272', 'Elena Underwood', 'elena.underwood78@example.com', 'Port Larkin', 'Harbor Rain Jacket', 9, 166.6, 'shipped', '2026-08-01', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (273, 'ORD-100273', 'Farid Lindqvist', 'farid.lindqvist79@example.com', 'Brightmoor', 'Trail Lantern', 7, 108.28, 'processing', '2026-03-05', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (274, 'ORD-100274', 'Quinn Zeller', 'quinn.zeller80@example.com', 'Maple Hollow', 'Sunrise Camp Stove', 3, 98.04, 'pending', '2026-02-20', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (275, 'ORD-100275', 'Yusuf Ivers', 'yusuf.ivers81@example.com', 'Silverbrook', 'Summit Tent 2P', 3, 295.71, 'cancelled', '2026-11-26', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (276, 'ORD-100276', 'Samir Jareth', 'samir.jareth82@example.com', 'Maple Hollow', 'Trail Lantern', 2, 333.66, 'processing', '2026-07-27', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (277, 'ORD-100277', 'Quinn Lindqvist', 'quinn.lindqvist83@example.com', 'Northwick', 'Alpine Thermos', 11, 415.57, 'returned', '2026-02-01', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (278, 'ORD-100278', 'Yusuf Pemberton', 'yusuf.pemberton84@example.com', 'Silverbrook', 'Ridgeline Trekking Poles', 11, 131.11, 'shipped', '2026-10-27', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (279, 'ORD-100279', 'Bastian Fairbanks', 'bastian.fairbanks85@example.com', 'Stonebridge', 'Meadow Picnic Set', 10, 287.37, 'pending', '2026-06-17', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (280, 'ORD-100280', 'Quinn Calloway', 'quinn.calloway86@example.com', 'Eastvale', 'Meadow Picnic Set', 12, 120.87, 'delivered', '2026-12-28', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (281, 'ORD-100281', 'Samir Zeller', 'samir.zeller87@example.com', 'Fernwood', 'Trail Lantern', 5, 419.52, 'cancelled', '2026-08-15', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (282, 'ORD-100282', 'Quinn Rosales', 'quinn.rosales88@example.com', 'Silverbrook', 'Trail Lantern', 4, 464.51, 'shipped', '2026-10-06', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (283, 'ORD-100283', 'Darius Jareth', 'darius.jareth89@example.com', 'Cedar Ridge', 'Glacier Water Filter', 1, 13.75, 'cancelled', '2026-12-07', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (284, 'ORD-100284', 'Amara Thornbury', 'amara.thornbury90@example.com', 'Ravenford', 'Pinecrest Sleeping Bag', 8, 253.14, 'cancelled', '2026-08-04', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (285, 'ORD-100285', 'Darius Whitlock', 'darius.whitlock91@example.com', 'Silverbrook', 'Trail Lantern', 5, 63.01, 'returned', '2026-10-17', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (286, 'ORD-100286', 'Darius Delacroix', 'darius.delacroix92@example.com', 'Eastvale', 'Cloudlight Hammock', 3, 262.03, 'shipped', '2026-04-05', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (287, 'ORD-100287', 'Ximena Marlowe', 'ximena.marlowe93@example.com', 'Silverbrook', 'Ridgeline Trekking Poles', 1, 450.32, 'returned', '2026-12-14', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (288, 'ORD-100288', 'Maya Brightwater', 'maya.brightwater94@example.com', 'Willowmere', 'Meadow Picnic Set', 6, 195.04, 'delivered', '2026-12-14', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (289, 'ORD-100289', 'Maya Rosales', 'maya.rosales95@example.com', 'Port Larkin', 'Meadow Picnic Set', 9, 74.22, 'cancelled', '2026-06-08', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (290, 'ORD-100290', 'Viktor Underwood', 'viktor.underwood96@example.com', 'Port Larkin', 'Meadow Picnic Set', 2, 256.89, 'pending', '2026-06-14', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (291, 'ORD-100291', 'Quinn Valdez', 'quinn.valdez0@example.com', 'Port Larkin', 'Summit Tent 2P', 3, 204.56, 'returned', '2026-08-21', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (292, 'ORD-100292', 'Zara Brightwater', 'zara.brightwater1@example.com', 'Port Larkin', 'Ridgeline Trekking Poles', 11, 299.75, 'cancelled', '2026-10-09', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (293, 'ORD-100293', 'Tamsin Delacroix', 'tamsin.delacroix2@example.com', 'Cedar Ridge', 'Canvas Daypack', 9, 11.0, 'shipped', '2026-01-10', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (294, 'ORD-100294', 'Jonah Lindqvist', 'jonah.lindqvist3@example.com', 'Ravenford', 'River Kayak Paddle', 2, 33.19, 'processing', '2026-05-03', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (295, 'ORD-100295', 'Samir Rosales', 'samir.rosales4@example.com', 'Fernwood', 'River Kayak Paddle', 8, 63.42, 'shipped', '2026-05-14', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (296, 'ORD-100296', 'Ines Hollins', 'ines.hollins5@example.com', 'Stonebridge', 'Canvas Daypack', 12, 264.27, 'returned', '2026-10-23', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (297, 'ORD-100297', 'Uma Marlowe', 'uma.marlowe6@example.com', 'Maple Hollow', 'Glacier Water Filter', 12, 178.92, 'processing', '2026-05-20', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (298, 'ORD-100298', 'Pavel Jareth', 'pavel.jareth7@example.com', 'Port Larkin', 'Summit Tent 2P', 6, 109.86, 'processing', '2026-09-13', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (299, 'ORD-100299', 'Amara Lindqvist', 'amara.lindqvist8@example.com', 'Silverbrook', 'Ridgeline Trekking Poles', 4, 158.54, 'delivered', '2026-08-09', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (300, 'ORD-100300', 'Greta Jareth', 'greta.jareth9@example.com', 'Port Larkin', 'Wildflower Seed Kit', 1, 79.9, 'pending', '2026-10-28', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (301, 'ORD-100301', 'Olivia Valdez', 'olivia.valdez10@example.com', 'Port Larkin', 'Glacier Water Filter', 7, 401.22, 'delivered', '2026-12-25', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (302, 'ORD-100302', 'Quinn Hollins', 'quinn.hollins11@example.com', 'Ravenford', 'Sunrise Camp Stove', 3, 202.67, 'cancelled', '2026-06-05', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (303, 'ORD-100303', 'Tamsin Thornbury', 'tamsin.thornbury12@example.com', 'Oakhaven', 'Alpine Thermos', 9, 49.7, 'cancelled', '2026-08-09', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (304, 'ORD-100304', 'Nikolai Delacroix', 'nikolai.delacroix13@example.com', 'Port Larkin', 'Cloudlight Hammock', 9, 283.06, 'returned', '2026-07-19', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (305, 'ORD-100305', 'Nikolai Ivers', 'nikolai.ivers14@example.com', 'Oakhaven', 'Pinecrest Sleeping Bag', 10, 57.29, 'returned', '2026-12-15', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (306, 'ORD-100306', 'Ximena Lindqvist', 'ximena.lindqvist15@example.com', 'Cedar Ridge', 'Meadow Picnic Set', 7, 254.67, 'processing', '2026-07-21', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (307, 'ORD-100307', 'Amara Yarrow', 'amara.yarrow16@example.com', 'Oakhaven', 'Harbor Rain Jacket', 7, 215.64, 'shipped', '2026-09-10', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (308, 'ORD-100308', 'Nikolai Sterling', 'nikolai.sterling17@example.com', 'Brightmoor', 'Pinecrest Sleeping Bag', 4, 46.31, 'delivered', '2026-06-27', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (309, 'ORD-100309', 'Keira Greystone', 'keira.greystone18@example.com', 'Brightmoor', 'Lakeshore Folding Chair', 1, 16.66, 'delivered', '2026-10-16', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (310, 'ORD-100310', 'Rosa Zeller', 'rosa.zeller19@example.com', 'Cedar Ridge', 'Glacier Water Filter', 10, 479.2, 'processing', '2026-09-24', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (311, 'ORD-100311', 'Maya Okafor', 'maya.okafor20@example.com', 'Northwick', 'Trail Lantern', 10, 326.05, 'returned', '2026-01-22', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (312, 'ORD-100312', 'Quinn Hollins', 'quinn.hollins21@example.com', 'Eastvale', 'Cloudlight Hammock', 6, 242.68, 'cancelled', '2026-09-19', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (313, 'ORD-100313', 'Greta Northcott', 'greta.northcott22@example.com', 'Harrowgate', 'Cloudlight Hammock', 8, 369.36, 'processing', '2026-06-23', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (314, 'ORD-100314', 'Farid Lindqvist', 'farid.lindqvist23@example.com', 'Northwick', 'Meadow Picnic Set', 2, 397.28, 'processing', '2026-03-04', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (315, 'ORD-100315', 'Wren Kingsley', 'wren.kingsley24@example.com', 'Oakhaven', 'Lakeshore Folding Chair', 9, 426.81, 'returned', '2026-11-06', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (316, 'ORD-100316', 'Quinn Greystone', 'quinn.greystone25@example.com', 'Lakeside Falls', 'Lakeshore Folding Chair', 4, 200.53, 'pending', '2026-11-19', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (317, 'ORD-100317', 'Luca Sterling', 'luca.sterling26@example.com', 'Ravenford', 'Tidewater Binoculars', 12, 24.62, 'returned', '2026-01-26', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (318, 'ORD-100318', 'Jonah Whitlock', 'jonah.whitlock27@example.com', 'Stonebridge', 'Glacier Water Filter', 1, 440.55, 'returned', '2026-02-19', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (319, 'ORD-100319', 'Viktor Abernathy', 'viktor.abernathy28@example.com', 'Maple Hollow', 'River Kayak Paddle', 8, 370.14, 'processing', '2026-05-28', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (320, 'ORD-100320', 'Samir Greystone', 'samir.greystone29@example.com', 'Brightmoor', 'Pinecrest Sleeping Bag', 2, 73.62, 'processing', '2026-09-04', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (321, 'ORD-100321', 'Darius Calloway', 'darius.calloway30@example.com', 'Silverbrook', 'Glacier Water Filter', 8, 395.9, 'processing', '2026-07-26', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (322, 'ORD-100322', 'Uma Abernathy', 'uma.abernathy31@example.com', 'Ravenford', 'Wildflower Seed Kit', 10, 158.0, 'cancelled', '2026-04-12', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (323, 'ORD-100323', 'Farid Brightwater', 'farid.brightwater32@example.com', 'Cedar Ridge', 'Tidewater Binoculars', 2, 413.11, 'processing', '2026-02-12', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (324, 'ORD-100324', 'Olivia Thornbury', 'olivia.thornbury33@example.com', 'Brightmoor', 'Trail Lantern', 1, 109.13, 'returned', '2026-10-25', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (325, 'ORD-100325', 'Olivia Brightwater', 'olivia.brightwater34@example.com', 'Westmere', 'Summit Tent 2P', 4, 110.49, 'shipped', '2026-10-28', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (326, 'ORD-100326', 'Keira Abernathy', 'keira.abernathy35@example.com', 'Fernwood', 'Ridgeline Trekking Poles', 8, 148.9, 'processing', '2026-05-16', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (327, 'ORD-100327', 'Hiro Valdez', 'hiro.valdez36@example.com', 'Brightmoor', 'Tidewater Binoculars', 12, 282.58, 'returned', '2026-05-13', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (328, 'ORD-100328', 'Amara Hollins', 'amara.hollins37@example.com', 'Eastvale', 'River Kayak Paddle', 3, 174.92, 'shipped', '2026-01-10', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (329, 'ORD-100329', 'Rosa Lindqvist', 'rosa.lindqvist38@example.com', 'Eastvale', 'Meadow Picnic Set', 9, 418.89, 'delivered', '2026-07-21', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (330, 'ORD-100330', 'Darius Northcott', 'darius.northcott39@example.com', 'Oakhaven', 'Lakeshore Folding Chair', 6, 267.85, 'returned', '2026-04-15', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (331, 'ORD-100331', 'Luca Hollins', 'luca.hollins40@example.com', 'Brightmoor', 'Trail Lantern', 5, 320.36, 'delivered', '2026-03-08', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (332, 'ORD-100332', 'Celia Greystone', 'celia.greystone41@example.com', 'Cedar Ridge', 'Glacier Water Filter', 3, 268.39, 'returned', '2026-04-06', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (333, 'ORD-100333', 'Luca Greystone', 'luca.greystone42@example.com', 'Stonebridge', 'Cloudlight Hammock', 7, 303.75, 'processing', '2026-04-10', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (334, 'ORD-100334', 'Quinn Greystone', 'quinn.greystone43@example.com', 'Maple Hollow', 'Ridgeline Trekking Poles', 8, 325.61, 'cancelled', '2026-05-20', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (335, 'ORD-100335', 'Samir Lindqvist', 'samir.lindqvist44@example.com', 'Lakeside Falls', 'Summit Tent 2P', 7, 293.7, 'shipped', '2026-03-28', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (336, 'ORD-100336', 'Viktor Quill', 'viktor.quill45@example.com', 'Eastvale', 'Glacier Water Filter', 5, 354.44, 'returned', '2026-01-22', 'Customer Care');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (337, 'ORD-100337', 'Jonah Abernathy', 'jonah.abernathy46@example.com', 'Brightmoor', 'Sunrise Camp Stove', 2, 334.81, 'shipped', '2026-06-07', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (338, 'ORD-100338', 'Celia Rosales', 'celia.rosales47@example.com', 'Fernwood', 'Meadow Picnic Set', 9, 365.14, 'shipped', '2026-02-23', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (339, 'ORD-100339', 'Celia Hollins', 'celia.hollins48@example.com', 'Cedar Ridge', 'River Kayak Paddle', 12, 194.21, 'delivered', '2026-07-28', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (340, 'ORD-100340', 'Yusuf Underwood', 'yusuf.underwood49@example.com', 'Fernwood', 'Tidewater Binoculars', 3, 449.92, 'shipped', '2026-01-12', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (341, 'ORD-100341', 'Nikolai Abernathy', 'nikolai.abernathy50@example.com', 'Ravenford', 'Sunrise Camp Stove', 12, 224.46, 'returned', '2026-06-21', 'Logistics');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (342, 'ORD-100342', 'Farid Jareth', 'farid.jareth51@example.com', 'Eastvale', 'Alpine Thermos', 10, 353.54, 'cancelled', '2026-11-02', 'Marketing');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (343, 'ORD-100343', 'Bastian Thornbury', 'bastian.thornbury52@example.com', 'Silverbrook', 'Cloudlight Hammock', 4, 364.43, 'shipped', '2026-07-24', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (344, 'ORD-100344', 'Rosa Jareth', 'rosa.jareth53@example.com', 'Ravenford', 'Tidewater Binoculars', 3, 272.94, 'shipped', '2026-10-16', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (345, 'ORD-100345', 'Nikolai Valdez', 'nikolai.valdez54@example.com', 'Ravenford', 'Pinecrest Sleeping Bag', 6, 449.41, 'pending', '2026-11-10', 'Operations');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (346, 'ORD-100346', 'Samir Thornbury', 'samir.thornbury55@example.com', 'Stonebridge', 'Trail Lantern', 4, 328.35, 'pending', '2026-06-07', 'Engineering');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (347, 'ORD-100347', 'Ximena Calloway', 'ximena.calloway56@example.com', 'Brightmoor', 'Sunrise Camp Stove', 12, 191.67, 'cancelled', '2026-10-27', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (348, 'ORD-100348', 'Ines Quill', 'ines.quill57@example.com', 'Eastvale', 'Meadow Picnic Set', 7, 214.94, 'delivered', '2026-12-17', 'Quality Assurance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (349, 'ORD-100349', 'Quinn Brightwater', 'quinn.brightwater58@example.com', 'Ravenford', 'Sunrise Camp Stove', 4, 208.18, 'processing', '2026-03-16', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (350, 'ORD-100350', 'Bastian Whitlock', 'bastian.whitlock59@example.com', 'Oakhaven', 'Wildflower Seed Kit', 9, 128.7, 'processing', '2026-03-25', 'Field Research');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (351, 'ORD-100351', 'Rosa Ivers', 'rosa.ivers60@example.com', 'Maple Hollow', 'Trail Lantern', 3, 174.65, 'returned', '2026-02-07', 'Finance');
INSERT INTO orders (id, order_code, customer, email, city, product, quantity, unit_price, status, order_date, department) VALUES (352, 'ORD-100352', 'Elena Everhart', 'elena.everhart61@example.com', 'Ravenford', 'Sunrise Camp Stove', 8, 323.24, 'shipped', '2026-12-08', 'Operations');
COMMIT;

-- Example query
SELECT city, ROUND(SUM(quantity * unit_price), 2) AS revenue FROM orders WHERE status <> 'cancelled' GROUP BY city ORDER BY revenue DESC;