CREATE TABLE repair_assignment (technician_id NUMBER, repair_id NUMBER, machine_id NUMBER)
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)

For each team, how many technicians are there?
SELECT team, COUNT(*) FROM technician GROUP BY team
SELECT "team", COUNT(*) FROM "technician" GROUP BY "team"