CREATE TABLE repair (repair_ID NUMBER, name CLOB, Launch_Date CLOB, Notes CLOB)
CREATE TABLE technician (technician_id FLOAT, Name CLOB, Team CLOB, Starting_Year FLOAT, Age NUMBER)
CREATE TABLE machine (Machine_ID NUMBER, Making_Year NUMBER, Class CLOB, Team CLOB, Machine_series CLOB, value_points FLOAT, quality_rank NUMBER)
CREATE TABLE repair_assignment (technician_id NUMBER, repair_ID NUMBER, Machine_ID NUMBER)

Show names of technicians and the number of machines they are assigned to repair Visualize by bar chart, and sort by the total number in asc.
SELECT Name, COUNT(*) FROM repair_assignment AS T1 JOIN technician AS T2 ON T1.technician_id = T2.technician_id GROUP BY T2.Name ORDER BY COUNT(*)
SELECT "Name", COUNT(*) FROM "repair_assignment" "T1" JOIN "technician" "T2" ON "T1"."technician_id" = "T2"."technician_id" GROUP BY "T2"."Name" ORDER BY COUNT(*)