You are working as a Fabric Analytics Engineer and have been given a task to analyze employee data stored in a Fabric lakehouse. The dataset includes employee details such as department, salary, and years of experience. Your manager has asked you to provide a report that shows the average salary for each department, ensuring the solution is cost-effective and scalable for future data growth. Which of the following SQL queries would you use to accurately retrieve the average salary for each department, along with the department name, while also considering best practices for performance and scalability? (Choose one correct answer)