Assign Letter Grades
Easy
Education & 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.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.