Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Assign Letter Grades

Assign a grade: marks >= 90 -> 'A', >= 75 -> 'B', >= 60 -> 'C', otherwise 'F'. Return name and grade ordered by name.

Table schema

Scores(student_id INT PRIMARY KEY, name VARCHAR(50), marks INT)

Sample data

student_id | name | marks
1 | Asha | 92
2 | Ben | 76
3 | Chitra | 60
4 | Dev | 45

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.