CREATE TABLE player (name_first VARCHAR, name_last VARCHAR, death_year VARCHAR)

Find all the players' first name and last name who have empty death record.
SELECT name_first, name_last FROM player WHERE death_year = ''
SELECT "name_first", "name_last" FROM "player" WHERE "death_year" = ''