CREATE TABLE technician (technician_id NUMBER, name CLOB, team CLOB, starting_year NUMBER, age 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 repair_assignment (technician_id NUMBER, repair_id NUMBER, machine_id NUMBER)

What are the names of the technicians and how many machines are they assigned to repair?
SELECT T2.name, COUNT(*) FROM repair_assignment AS T1 JOIN technician AS T2 ON T1.technician_id = T2.technician_id GROUP BY T2.name
SELECT "T2"."name", COUNT(*) FROM "repair_assignment" "T1" JOIN "technician" "T2" ON "T1"."technician_id" = "T2"."technician_id" GROUP BY "T2"."name"