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.
  1. Prepare
  2. SQL
  3. Basic Join
  4. The Report
  5. Discussions

The Report

Sort by

recency

|

3563 Discussions

|

  • ashleytyq
     + 0 comments

    select CASE WHEN g.Grade < 8 THEN "NULL" ELSE s.Name END, g.Grade, s.Marks FROM Students as s join Grades as g on s.Marks BETWEEN g.Min_Mark AND g.Max_Mark order by g.Grade desc, CASE WHEN g.Grade < 8 THEN s.Marks ELSE s.Name END asc

  • amethystskye_pi
     + 0 comments
    SELECT 
CASE
    WHEN Grade < 8 THEN NULL
    ELSE Name
END AS Name
, Grade
, Marks
FROM Students
JOIN Grades
ON Students.Marks BETWEEN Grades.Min_Mark AND Grades.Max_Mark
ORDER BY Grade DESC, (
    CASE 
        WHEN Grade < 8 THEN Marks
        ELSE Name
    END
) ASC

  • sabhijot037
     + 0 comments

    SELECT CASE WHEN g.grade < 8 THEN 'NULL' ELSE s.name END AS name, g.grade, s.marks FROM Students s JOIN Grades g ON s.marks BETWEEN g.min_mark AND g.max_mark ORDER BY g.grade DESC, CASE WHEN g.grade >= 8 THEN s.name END ASC, CASE WHEN g.grade < 8 THEN s.marks END ASC;

  • dilipsunar1216
     + 0 comments

    Without Using Join

    select 
case  
    when marks>=70 then name
    else null
    end as Name,
case 
 when marks=100 then 10
 else floor((marks/10)+1)
 end as grade, marks
from Students
order by grade desc,name;
# **

  • SVVBathini_w
     + 1 comment

    For MySQL Platform

    SELECT
    CASE
        WHEN grades.grade >= 8 THEN students.name
        ELSE NULL
    END AS "toppers_list",
    grades.grade, students.marks FROM students
JOIN grades ON students.marks BETWEEN grades.min_mark AND grades.max_mark
ORDER BY grades.grade DESC, toppers_list, students.marks;