Cumulative Distribution (CUME_DIST)

Problem

The admissions office wants to analyze what proportion of students scored less than or equal to a given test grade. Calculate the cumulative distribution of scores in the grades table. Output student_id, score, and cume_dist.

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