seeds.sql

 -- Creates new rows containing data in all named columns --
  INSERT INTO products
    (product_name, department_name, price, stock_quantity)
  VALUES
    ("Origin", "Books & Audible", 17.96 , 32);

  INSERT INTO products
    (product_name, department_name, price, stock_quantity)
  VALUES
    ("Nizoral A-D Anti-Dandruff Shampoo, 7 Oz", "Beauty & Health", 14.10, 12);

  INSERT INTO products
    (product_name, department_name, price, stock_quantity)
  VALUES
    ("Bob's Red Mill Oat Bran Cereal, 18 oz", "Food & Grocery", 7.29, 34);

  INSERT INTO products
    (product_name, department_name, price, stock_quantity)
  VALUES
    ("Invictus", "Books & Audible", 13.29, 5);  

  INSERT INTO products
    (product_name, department_name, price, stock_quantity)
  VALUES
    ("Giraffes Can't Dance", "Books & Audible", 5.33, 20);
    
  INSERT INTO products
    (product_name, department_name, price, stock_quantity)
  VALUES
    ("Doritos Nacho Cheese Flavored Tortilla Chip, 15 oz", "Food & Grocery", 4.55, 75);  

  INSERT INTO products
    (product_name, department_name, price, stock_quantity)
  VALUES
    ("Special K Kellogg's Cereal, Red Berries, 16.90 Oz", "Food & Grocery", 3.99, 60);
    
  INSERT INTO products
    (product_name, department_name, price, stock_quantity)
  VALUES
    ("Kellogg's Breakfast Cereal Assortment Pack", "Food & Grocery", 16.94, 50);
    
  INSERT INTO products
    (product_name, department_name, price, stock_quantity)
  VALUES
    ("Neutrogena Anti-Residue Shampoo, 6 Fl. Oz.", "Beauty & Health", 4.65, 15);
              
  INSERT INTO products
    (product_name, department_name, price, stock_quantity)
  VALUES
    ("The Honest Spy", "Books & Audible", 10.79, 4);

INSERT INTO departments
    (department_name, over_head_costs)
  VALUES
    ("Books & Audible", 100);

INSERT INTO departments
    (department_name, over_head_costs)
  VALUES
    ("Beauty & Health", 200);

INSERT INTO departments
    (department_name, over_head_costs)
  VALUES
    ("Food & Grocery", 150);

INSERT INTO departments
    (department_name, over_head_costs)
  VALUES
    ("Sports & Outdoors", 500);

INSERT INTO departments
    (department_name, over_head_costs)
  VALUES
    ("Electronics", 300);