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)
names of technicians not assigned to repair machines refers to selecting technicians whose technician_id is NOT IN the list of technician_ids in repair_assignment table;