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
Sunday, August 13, 2023
Student Marks & Grade SQL Real Problem Statement#sqlinterviewquestionsandanswers
Subscribe to:
Post Comments (Atom)
"๐ 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...
-
What is Azure Data Factory? * Azure Data Factory is a managed cloud service that's built for these complex hybrid extract-transform-lo...
-
---- L&T SQL Interview Problem | Print Highest and Lowest Salary Employees in Each Department---- ----- create table employee ( emp_na...
-
๐ Understanding Delta Lake: Bridging the Gap Between Data Lakes and Data Warehouses ๐ In today's data-driven world, organizations lev...
No comments:
Post a Comment