Show the names of all technicians.
select name from technician
Show the names of all technicians and the machines they are assigned to.
select t3.name, t1.machine_id 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
Show the names of all technicians assigned to the machine with ID 2.
select t3.name, t1.machine_id 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 and t1.machine_id = 2
Show the names of all technicians in ascending order of quality rank assigned to the machine with ID 2.
select t3.name, t1.machine_id, quality_rank 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 and t1.machine_id = 2 order by quality_rank
Show the names of all technicians in ascending order of quality rank assigned to the machine with ID 1.
select t3.name, t1.machine_id, quality_rank 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 and t1.machine_id = 1 order by quality_rank
Show the names of technicians in ascending order of quality rank of the machine they are assigned.
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