We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- SQL
- Basic Join
- The Report
- Discussions
The Report
The Report
Sort by
recency
|
3110 Discussions
|
Please Login in order to post a comment
MySQL:
MY SQL SELECT 5 CASE 6 WHEN g.grade < 8 THEN 'NULL' 7 ELSE s.name 8 END AS name, 9 g.grade, 10 s.marks 11 FROM students s 12 INNER JOIN grades g 13 ON s.marks BETWEEN g.min_mark AND g.max_mark 14 ORDER BY g.grade DESC, s.name;
For Oracle
SELECT CASE WHEN marks >= 70 THEN name ELSE NULL END as name1, CASE WHEN marks BETWEEN min_mark AND max_mark THEN grade END as grade ,marks FROM students JOIN grades ON marks BETWEEN min_mark AND max_mark order by grade desc,name asc,marks asc
with grading as( select name,marks, case when marks%10 !=0 or marks=100 then ceil(marks/10) else ceil((marks/10)+1) end as grades from students) select case when grades < 8 then null else NAME END as name, Grades , Marks from grading order by grades desc, name asc,marks asc