📊 20 Practical Data Analysis Questions (Calculation & Filter Based)

1. What is the average salary of all employees?

2. How many employees are older than 40 years?

3. List all employees in the 'IT' department.

4. What is the total salary paid to the 'Finance' department?

5. Who is the highest-paid employee?

6. What is the minimum salary in the 'Sales' department?

7. How many employees are aged between 30 and 45?

8. List the top 5 employees with the highest salaries.

9. Group employees by department and count how many are in each.

10. What is the average age of employees in each department?

11. List employees whose names start with 'A'.

12. Find the employee with the lowest salary in the 'Marketing' department.

13. Sort all employees by salary in descending order.

14. Which department has the highest total salary expenditure?

15. List all employees with email addresses ending in 'gmail.com'.

16. Calculate the median age of all employees.

17. Which department has the youngest average age?

18. Count how many employees earn more than 75,000.

19. List all employees with salaries between 60,000 and 80,000.

20. Export only 'Name', 'Department', and 'Salary' columns to a new CSV.