Practice with SELECT and UPDATE

sqltables2.sql

SELECT pet.id, pet.name, pet.dead, pet.breed_id, pet.adopted 
    FROM pet, breed, species 
    WHERE
    pet.breed_id = breed.id AND
    breed.species_id = species.id AND
    species.id = 2;

UPDATE pet SET adopted = 0 IN (
    SELECT pet.adopted 
    FROM pet, breed, species 
    WHERE
    pet.breed_id = breed.id AND
    breed.species_id = species.id AND
    species.id = 2
);

 SELECT pet.id, pet.name, pet.dead, pet.breed_id, pet.adopted 
    FROM pet, person, person_pet 
    WHERE
    person.id = person_pet.person_id AND
    pet.id = person_pet.pet_id AND
    person.id = 2;

UPDATE pet SET adopted = 1 WHERE adopted IN (
    SELECT pet.adopted
    FROM pet, breed, species, person, person_pet
    WHERE
    pet.breed_id = breed.id AND
    breed.species_id = species.id AND
    species.id = 2 AND
    person.id = person_pet.person_id AND
    pet.id = person_pet.pet_id AND
    person.id = 2
);