4.2 ⚙️ Datenverarbeitung vor Beginn

DROP TABLE cats;
DROP TABLE cats2;
DROP TABLE cats3;
DROP TABLE cats4;
DROP TABLE unique_cats;
DROP TABLE unique_cats2;
DROP TABLE unique_cats3;

CREATE TABLE cats
  (
      cat_id   INT AUTO_INCREMENT,
      name   VARCHAR(100),
      breed   VARCHAR(100),
      age   INT,
      PRIMARY KEY (cat_id)
  );

INSERT INTO cats (name, breed, age)
VALUES ('Ringo', 'Tabby', 4),
            ('Cindy', 'Maine Coon', 10),
            ('Dumbledore', 'Maine Coon', 11),
            ('Egg', 'Persian', 4),
            ('Misty', 'Tabby', 13),
            ('George Michael', 'Ragdoll', 9),
            ('Jackson', 'Sphynx', 7);