Update Rows Based On Another Table

-- Create table called elves
CREATE TABLE elves (
    -- string variable
    name varchar(255),
    -- integer variable
    age int,
    -- string variable
    race varchar(255),
    -- string variable
    alive varchar(255)
)

-- Create table called deaths
CREATE TABLE deaths (
    -- string variable
    name varchar(255)
)

INSERT INTO elves (name, age, race, alive)
VALUES ('Dallar Woodfoot', 25, 'Elf', 'Yes'),
       ('Cordin Garner', 29, 'Elf', 'Yes'),
       ('Keat Knigh', 24, 'Elf', 'Yes'),
       ('Colbat Nalor', 124, 'Elf', 'Yes')

INSERT INTO deaths (name)
VALUES ('Keat Knigh'),
       ('Colbat Nalor')

-- Retrieve all rows from the view Elf
SELECT * FROM elves

-- Change the value in elves
UPDATE elves
-- to set alive to "No"
SET alive = 'No'
-- Where the name of the elf is in the list of deaths
WHERE elves.name in (SELECT deaths.name FROM deaths)

-- Retrieve all rows from the view Elf
SELECT * FROM elves