List the first and last name of all players who are left / L hand in the order of birth date.
CREATE TABLE players (first_name VARCHAR, last_name VARCHAR, hand VARCHAR, birth_date VARCHAR)
SELECT first_name, last_name FROM players WHERE hand = 'L' ORDER BY birth_date
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE players (first_name VARCHAR, last_name VARCHAR, hand VARCHAR, birth_date VARCHAR) Question: List the first and last name of all players who are left / L hand in the order of birth date. [/INST] SELECT first_name, last_name FROM players WHERE hand = 'L' ORDER BY birth_date </s>