Show ids for all employees who don't have a certificate.
create table employee (eid varchar, PRIMARY KEY (eid)); create table certificate (eid varchar, PRIMARY KEY (eid))
select eid from employee except select eid from certificate