A university is analyzing exam scores by department. Within…
A university is analyzing exam scores by department. Within the Math department, scores are ordered by exam date from oldest to newest. If the university uses LAST_VALUE(score), what result will be returned for Math? A) The lowest exam score in Math B) The average exam score in Math C) The most recent exam score in Math D) The highest exam score in Math Correct Answer: The most recent exam score in Math Explanation:Last value returns the value from the end of the ordered window. Since the window is ordered by date (oldest to newest), the final row corresponds to the most recent exam score. The lowest or highest score would only appear if the ordering were based on score rather than date. The average would require an aggregate function, not a window function.