INSERT INTO Advertisements (Ad_ID, Ad_Name, Type, Duration, Budget, Platform_ID, Campaign_ID)
VALUES
	(0001, 'Product Launch', 'Video', 30, 4500, 0003, 0004),
  (0002, 'Friends Forever', 'Display', 30, 3000, 0005, 0006),
  (0003, 'Discounts','Email', 0, 300, 0002, 0003),
  (0004, 'Your New Bestie','Display', 20, 700, 0004, 0002),
  (0005, 'New Flavors','Video', 60, 9000, 0001, 0001),
  (0006, 'Listen Like A Pro', 'Video', 45, 12000, 0006, 0005);

INSERT INTO Campaigns (Campaign_ID, Campaign_Name, Manager_ID, StartDate, EndDate, Budget, Client_ID)
VALUES
	(0001, 'Coke Zero Sugar', 0005, '2024-01-15', '2024-02-15', 12000, 0004),
  (0002, 'Petco Pets', 0004, '2024-02-20', '2024-03-10', 11000, 0002),
  (0003, 'Weekly Circular', 0002, '2024-02-20', '2025-03-19', 27000, 0001),
  (0004, 'iPhone 16 Launch', 0001, '2024-05-16', '2024-07-15', 24000, 0003),
  (0005, 'Airpods Max Launch', 0001, '2024-09-22', '2024-12-31', 40000, 0003),
  (0006, 'Sharing Memories', 0003, '2024-06-01','2024-08-31', 26000, 0005);

INSERT INTO Clients (Client_ID, CompanyName, Address, Email, Phone, ContactPerson)
VALUES
  (0001, 'ShopRite', '8 Northwood Avenue Fairfield, CT', 'shoprite.stores@gmail.com', '9082096511', 'Susan Samovic'),
  (0002, 'Petco', '345 Dakota Drive Wilmington, DE', 'petcopets@gmail.com', '4598650099', 'Logan Drobim'),
  (0003, 'Apple', '1 Apple Park Way Cupertino, CA', 'apple.products@gmail.com', '2822619865', 'Luca Mandzukic'),
  (0004, 'Coca Cola', '45 Elm Street New York City, NY', 'cocacola@gmail.com', '7183547865', 'Elma Woods'),
	(0005, 'Instagram', '832 Menlo Avenue Menlo Park, CA', 'instagram@gmail.com', '2983326021', 'Oliver Kirk');

INSERT INTO Contents (Content_ID, Title, Description, Media_Type, Creation_Date, Campaign_ID)
VALUES
	(0001, 'Airpods Max', 'Describes the new and cool features of the headphones', 'Video', '2024-09-18', 0005),
  (0002, 'Adopt A Pet', 'Graphics and words about adopting pets and being friends', 'Display', '2024-02-01', 0002),
  (0003, 'Coke Zero Sugar', 'Celebs trying the new flavor', 'Video', '2024-01-01', 0001),
  (0004, 'Making Mems', 'Many posts of various topics to show the idea of memories', 'Display', '2024-06-01', 0006),
  (0005, 'Weekly Circular', 'A reminder and file of the new discounts for the week', 'Email', '2024-02-05', 0003),
  (0006, 'Phony Phones', 'Inroducing the new iPhone 16 and features', 'Video', '2024-04-27', 0004);

INSERT INTO Employees (Emp_ID, First_Name, Last_Name, Address, Email, Phone, Supervisor)
VALUES
  (0001, 'Sara', 'Smith', '234 Camelot Drive Palmer, PA', 'sara.smith@marketflash.org', '9734214500', 0003),
  (0002, 'John', 'Doe', '9478 Warne Way Washington, NJ', 'john.doe@marketflash.org', '8097621110', 0004),
  (0003, 'Samira', 'Okifi', '8 Elizabeth Avenue Tampa, FL', 'samira.okifi@marketflash.org', '3951253792', 0002),
  (0004, 'Alexandra', 'Clements', '21 Charen Street Houston, TX', 'alexandra.clements@marketflash.org', '2836934018', 0005),
  (0005, 'Kiren', 'Nadanam', '61 Springfield Way Tacoma, OK', 'kiren.nadanam@marketflash.org', '9234601724', 0001);

INSERT INTO Influencers(Influencer_ID, Influencer_Name, Social_Handle, Follower_Count, Email, Phone, Campaign_ID)
VALUES
  (0001, 'Sophia Cabron', 'sophcabron', '780564','soph.cabron@gmail.com', '2397345986', 0002),
  (0002, 'Lebron James', 'lebron', '4200000', 'kingjames@nba.org', '7295015682', 0001),
  (0003, 'Alix Earle', 'alixearle', '2896532', 'alixearle@inquires.com', '3967128894', 0001),
  (0004, 'David Fischer', 'fischhh', '764212', 'fischman.david@gmail.com', '2957821345', 0004),
  (0005, 'Alessia Caro', 'alessiaC', '97342', 'caroAles@inquiries.com', '2389547183', 0002);
   
INSERT INTO Metrics (Metric_ID, Impressions, Clicks, Engagement, Conversion_Rate, Campaign_ID)
VALUES
  (0001, 860000000, 500000000, 360000000, 41.86, 0001),
  (0002, 564230887, 423564333, 333224444, 59.05, 0006),
  (0003, 298234111, 267990078, 189555476, 63.55, 0003),
  (0004, 1200000000, 876455321, 666342189, 55.52, 0004),
  (0005, 980375, 406523, 243578, 24.84, 0002),
  (0006, 998965400, 349877022, 233455680, 23.36, 0005);

INSERT INTO Payments (Payment_ID, Date, Amount, Payment_Type, Campaign_ID)
VALUES
	(0001, '2025-01-01', 45000, 'Credit', 0005),
  (0002, '2025-03-05', 17300, 'Cash', 0003),
  (0003, '2024-09-01', 30000, 'Credit', 0006),
  (0004, '2024-03-15', 11500, 'Check', 0002),
  (0005, '2024-02-01', 19000, 'Check', 0001),
  (0006, '2024-07-03', 31250, 'Credit', 0004);
   
INSERT INTO Platforms (Platform_ID, Platform_Name, URL, Contact_Person, Contact_Phone, Contact_Email, Campaign_ID)
VALUES
	(0001, 'Email', 'gmail.com', 'Gloria Simmons', '3928935920', 'simmons.gloria@gmail.com', 0003),
  (0002, 'Instagram','instagram.com', 'Evangelina Benedetti', '9971034200', 'bennedetti@instahelp.com', 0002),
  (0003, 'Youtube', 'youtube.com', 'Markus Erikson', '4814002050', 'Erikson.Markus@youtube.org', 0004),
  (0004, 'Facebook', 'facebook.com', 'Kyle Roth', '9082391822', 'rothK.facebook@inquires.com', 0006),
  (0005, 'TikTok', 'tiktok.com', 'Erica Wasserman', '2938570928', 'Wass_Er@tiktok.org', 0001),
  (0006, 'Snapchat', 'snapchat.com', 'Peter Dovic', '3051923499', 'DovicP@snapchat.com', 0005);