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

A bar chart for what are the number of the names of the technicians that are assigned to repair machines with more point values than 70?, list in asc by the names.
SELECT Name, COUNT(Name) 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 WHERE T2.value_points > 70 GROUP BY Name ORDER BY Name
SELECT "Name", COUNT("Name") FROM "repair_assignment" "T1" JOIN "machine" "T2" ON "T1"."Machine_ID" = "T2"."Machine_ID" AND "T2"."value_points" > 70 JOIN "technician" "T3" ON "T1"."technician_id" = "T3"."technician_id" GROUP BY "Name" ORDER BY "Name"