Student Marks & Grade SQL Real Problem Statement#sqlinterviewquestionsandanswers

We have two tables Student Marks & Grade

i-Find the grade of each student & Sort the table by  descending  grade


ii-If any student's Grade is below 7th Grade then they  sort the table in Ascending order of their Total Marks for these students only

iii-If the Grade is greater than OR Equal to 7  then sort the table by name Alphabetically for these Students only

Check out my solution on:

https://www.youtube.com/watch?v=Hop7ULM53_U

Download the code & Sample Input