List top 10 employee work longest in the company. List employee's first and last name.
CREATE TABLE employees (first_name VARCHAR, last_name VARCHAR, hire_date VARCHAR)
SELECT TOP 10 first_name, last_name FROM employees ORDER BY hire_date
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE employees (first_name VARCHAR, last_name VARCHAR, hire_date VARCHAR) Question: List top 10 employee work longest in the company. List employee's first and last name. [/INST] SELECT TOP 10 first_name, last_name FROM employees ORDER BY hire_date </s>