ex7.sql

/* make sure there's dead pets */
SELECT name, age FROM pet WHERE dead = 1;

/* aww poor robot */
DELETE FROM pet WHERE dead = 1;

/* make sure the robot is gone */
SELECT * FROM pet;

/* let's resurrect the robot */
INSERT INTO pet(id, name, breed, age, dead)
  VALUES(1, "Gigantor", "Robot", 1, 0);

/* the robot LIVES! */
SELECT * FROM pet;