Database: assets_maintenance
Question: Which engineers have never visited to maintain the assets? List the engineer first name and last name.
SQL:
SELECT first_name ,  last_name FROM Maintenance_Engineers WHERE engineer_id NOT IN (SELECT engineer_id FROM Engineer_Visits)