Find all the players' first name and last name who have empty death record.
CREATE TABLE player (name_first VARCHAR, name_last VARCHAR, death_year VARCHAR)
SELECT name_first, name_last FROM player WHERE death_year = ''
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE player (name_first VARCHAR, name_last VARCHAR, death_year VARCHAR) Question: Find all the players' first name and last name who have empty death record. [/INST] SELECT name_first, name_last FROM player WHERE death_year = '' </s>