SELECT Name FROM technician WHERE technician_id NOT IN (SELECT technician_id FROM repair_assignment)
What are the names of the technicians that have not been assigned to repair machines?
SELECT Name FROM technician WHERE technician_id NOT IN ( SELECT technician_id FROM repair_assignment )
select name from technician where technician_id not in ( select technician_id from repair_assignment )
What are the names of the technicians that have not been assigned to repair machines ?