Finding the Last Value (LAST_VALUE)

Problem

The student council wants to track student performance trends. Find the student's current score and the last score recorded for them in the grades table. Output student_id, score, and last_score (use default window framing rules correctly).

Database Schema

Table: students

• id (INT): Unique identifier for the student.
• name (VARCHAR): Full name of the student.
• grade_level (INT): The student's current grade level (9-12).
• enrollment_year (INT): The year the student enrolled.

Table: courses

• id (INT): Unique identifier for the course.
• name (VARCHAR): Name of the course.
• subject (VARCHAR): Subject area (e.g., Math, Science).
• credits (INT): Number of course credits.

Table: grades

• id (INT): Unique identifier for the grade entry.
• student_id (INT): Foreign key referencing the student.
• course_id (INT): Foreign key referencing the course.
• score (INT): Numeric score (0-100).
• term (VARCHAR): Term of the grade (e.g., Fall 2022).

Try It

Hint

Solution