Which engineers have never visited to maintain the assets? List the engineer first name and last name.
create table engineer_visits (first_name varchar, last_name varchar, engineer_id varchar, PRIMARY KEY (first_name)); create table maintenance_engineers (first_name varchar, last_name varchar, engineer_id varchar, PRIMARY KEY (first_name))
select first_name, last_name from maintenance_engineers where not engineer_id in (select engineer_id from engineer_visits)