Can you list the states where the secretaries of the Treasury department were born?
select t3.born_state from department as t1 join management as t2 on t1.department_id = t2.department_id join head as t3 on t2.head_id = t3.head_id where t1.name = 'Treasury'
Can you list the states where the secretaries of the Homeland Security department were born?
select t3.born_state from department as t1 join management as t2 on t1.department_id = t2.department_id join head as t3 on t2.head_id = t3.head_id where t1.name = 'Homeland Security'
What departments employ more than 100,000 employees?
select * from department where num_employees > 100000