🎁 Exclusive Offer! Join our
Telegram Channel
to get **special discounts** and updates! 🚀
Question 91 - 100% Working Solution | Buy Now
Description
4 Live
You are helping your professor at the university to generate a report containing three columns: name, grade, and mark. You are given a table of grades and students. Your professor has instructed you to create the report according to the following specifications:
- He doesn't want the names of those students who received a grade lower than 'C'.
- Higher grades in the report should be entered first.
- If there is more than one student with the same grade (C - A) assigned to them, order those particular students by their name alphabetically.
- Finally, if the grade is lower than 'C', use "NULL" as their name and list them by their grades in descending order. If there is more than one student with the same grade (F - D) assigned to them, order those particular students by their marks in ascending order.
The grades table contains the following columns:
- grade: letter from A to F
- min_mark: the minimum mark a student must achieve in order to reach this particular letter grade
- max_mark: the maximum mark a student can achieve in order to get this particular grade