show names of technicians by order of quality rank of machine they are assigned from worst to best
select t3.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 order by t2.quality_rank
What is the Name of the oldest technician?
select name from technician order by age desc limit 1
What is the name of the Team with the most number of value points?
select team from machine order by value_points desc limit 1
What was the Making Year of the Machine series With the lowest quality rank?
select making_year from machine order by quality_rank limit 1