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
Show the starting years shared by technicians from team 'CLE' and 'CWS'.
assistant
SELECT Starting_Year FROM technician WHERE Team = 'CLE' INTERSECT SELECT Starting_Year FROM technician WHERE Team = 'CWS'
human
How many technicians are there?
assistant
SELECT count(*) FROM technician
human
Show the name of technicians aged either 36 or 37
assistant
SELECT Name FROM technician WHERE Age = 36 OR Age = 37
human
List the names of technicians in ascending order of age.
assistant
SELECT Name FROM technician ORDER BY Age ASC
human
What are the team and starting year of technicians?
assistant
SELECT Team , Starting_Year FROM technician
human
What is the starting year for the oldest technician?
assistant
SELECT Starting_Year FROM technician ORDER BY Age DESC LIMIT 1 ;