In SQL,

1. How many employees joined the organization during the last 5 years (starting from the last hire date)?
   • how many of them are male/female?
2. What's the mean age of
   • males
   • females
   • all employees
3. Which departments have more male employees than females and vice-versa?
4. What's the fraction of employees has changed departments in the last decade (starting from the last hire date to 10 years back from that year)
   • male
   • female
   • all employees