Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You are working with a lakehouse in Fabric that contains a table named 'Employees' with columns 'EmployeeID', 'FirstName', 'LastName', 'Department', and 'Salary'. You need to write a SQL query to find the average salary for each department. How would you structure this query?
A
SELECT Department, AVG(Salary) AS AverageSalary FROM Employees GROUP BY Department;
B
SELECT Department, Salary AS AverageSalary FROM Employees;
C
SELECT Department, AVG(Salary) AS AverageSalary FROM Employees;
D
SELECT Department, Salary AS AverageSalary FROM Employees GROUP BY Department;