human
Schema:
repair (repair_ID, name, Launch_Date, Notes)
machine (Machine_ID, Making_Year, Class, Team, Machine_series, value_points, quality_rank)
technician (technician_id, Name, Team, Starting_Year, Age)
repair_assignment (technician_id, repair_ID, Machine_ID)
Please answer with SQL.
assistant
Sure, I understand.
human
List out the all technician name
assistant
SELECT Name FROM technician;
human
list out the all machine id
assistant
SELECT machine_id FROM repair_assignment;
human
list out the all technician age
assistant
SELECT technician_id , age FROM technician ;