Show names of technicians and series of machines they are assigned to repair.
create table machine (machine_series varchar, machine_id varchar, PRIMARY KEY (machine_series)); create table repair_assignment (machine_id varchar, technician_id varchar, PRIMARY KEY (machine_id)); create table technician (name varchar, technician_id varchar, PRIMARY KEY (name))
select t3.name, t2.machine_series from repair_assignment as t1 join machine as t2 on t1.machine_id = t2.machine_id join technician as t3 on t1.technician_id = t3.technician_id