Publicis Sapient Interview Question

Write an sql script to retrieve employee info against department along with count etc.