Yes, please
select count ( distinct dept_name ) from student
Sorry, I meant instructors
select count ( i_id ) from advisor
Can you show me the id of the instructor who is from the History department?
select i_id from advisor as t1 join student as t2 on t1.s_id = t2.id where t2.dept_name = 'History'