Ultimate access to all questions.
As a Fabric Analytics Engineer, you are working with a lakehouse that contains a dataset of employee performance reviews. The dataset includes columns for EmployeeID, ReviewDate, and PerformanceScore. Your manager has asked you to generate a report that shows the average performance score for each employee, sorted from highest to lowest average score. Additionally, the report must exclude any employees who have fewer than 3 reviews to ensure statistical significance. Which SQL query would you use to accomplish this task? Choose the correct option from the following: