Show ids for all employees who don't have a certificate.
CREATE TABLE Employee (eid VARCHAR); CREATE TABLE Certificate (eid VARCHAR)
SELECT eid FROM Employee EXCEPT SELECT eid FROM Certificate
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Employee (eid VARCHAR); CREATE TABLE Certificate (eid VARCHAR) Question: Show ids for all employees who don't have a certificate. [/INST] SELECT eid FROM Employee EXCEPT SELECT eid FROM Certificate </s>