Sunday, August 13, 2023

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


No comments:

Post a Comment

"๐Ÿš€ Delta Lake's Vectorized Delete: The Secret to 10x Faster Data Operations!"

"๐Ÿš€ Delta Lake's Vectorized Delete: The Secret to 10x Faster Data Operations!" Big news for data engineers! Delta Lake 2.0+ in...