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 (repair_ID NUMBER, name CLOB, Launch_Date CLOB, Notes CLOB)
CREATE TABLE repair_assignment (technician_id NUMBER, repair_ID NUMBER, Machine_ID NUMBER)

Display a bar chart for what are the names of the technicians and how many machines are they assigned to repair?, and display by the the total number in desc.
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(*) DESC
SELECT "Name", COUNT(*) FROM "repair_assignment" "T1" JOIN "technician" "T2" ON "T1"."technician_id" = "T2"."technician_id" GROUP BY "T2"."Name" ORDER BY COUNT(*) DESC