What are the full name (first and last name) and salary for all employees who does not have any value for commission?
CREATE TABLE employees (first_name VARCHAR, last_name VARCHAR, salary VARCHAR, commission_pct VARCHAR)
SELECT first_name, last_name, salary FROM employees WHERE commission_pct = "null"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE employees (first_name VARCHAR, last_name VARCHAR, salary VARCHAR, commission_pct VARCHAR) Question: What are the full name (first and last name) and salary for all employees who does not have any value for commission? [/INST] SELECT first_name, last_name, salary FROM employees WHERE commission_pct = "null" </s>