human
Schema:
department (Department_ID, Name, Creation, Ranking, Budget_in_Billions, Num_Employees)
head (head_ID, name, born_state, age)
management (department_ID, head_ID, temporary_acting)
Please answer with SQL.
assistant
Sure, I understand.
human
How many employees does each department have?
assistant
SELECT num_employees FROM department;
human
What is the number of employees of the departments whose rank is between 10 and 15?
assistant
SELECT num_employees FROM department WHERE ranking BETWEEN 10 AND 15 ;