CREATE TABLE repair_assignment (technician_id NUMBER, repair_id NUMBER, machine_id NUMBER)
CREATE TABLE repair (repair_id NUMBER, name CLOB, launch_date CLOB, notes CLOB)
CREATE TABLE machine (machine_id NUMBER, making_year NUMBER, class CLOB, team CLOB, machine_series CLOB, value_points NUMBER, quality_rank NUMBER)
CREATE TABLE technician (technician_id NUMBER, name CLOB, team CLOB, starting_year NUMBER, age NUMBER)

Show names of technicians and series of machines they are assigned to repair.
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
SELECT "T3"."name", "T2"."machine_series" FROM "repair_assignment" "T1" JOIN "machine" "T2" ON "T1"."machine_id" = "T2"."machine_id" JOIN "technician" "T3" ON "T1"."technician_id" = "T3"."technician_id"