Groupby() and Aggregate functions scenario based questions:
1.Find the female employees?
2.Find the male employees ?
3.Find the female employees who belong to Admin Dept?
4.Find the male employees who belong to Accounts Dept?
5. Find the male who belong to Accounts Dept and highly paid?
6.Find the female employees who belong to Admin Dept and least paid?
7.Find the female employees who belong to Admin Dept average age?