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

|

3397 Discussions

|

  • govind3g21
     + 0 comments

    SELECT CASE WHEN g.Grade >= 8 THEN s.Name ELSE 'NULL' END, 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, s.Name;

  • chaitanyamet25
     + 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
        ELSE NULL
    END ASC,
    CASE
        WHEN G.Grade < 8 THEN S.Marks
        ELSE NULL
    END ASC;

  • adityaaher5703
     + 0 comments

    SELECT CASE WHEN G.GRADE >= 8 THEN S.NAME ELSE 'NULL' END, G.GRADE, S.MARKS FROM STUDENTS S, GRADES G WHERE S.MARKS >= MIN_MARK AND S.MARKS <= MAX_MARK ORDER BY G.GRADE DESC, S.NAME, S.MARKS;

  • abhishekboga99
     + 0 comments

    SQL Code using CTE:

    with report as 
(
select
    name,
    grade,
    marks
from students
join grades
on students.marks between grades.min_mark and grades.max_mark
)
select 
    case when grade>=8 then name
         else null end, 
    grade,
    marks
from report
order by grade desc, name;

  • ksudhan1018
     + 0 comments

    I have used the following querry,it throws error could someone help me out

    with cte1 as ( Select Name , Grade , Marks from students s left join grades g on s.marks >= g.min_mark and s.marks<=g.max_mark )

    Select case when grade < 8 then 'Null' else Name end ,Grade,marks from cte1 order by grade desc,CASE WHEN Grade >= 8 THEN Name ELSE NULL END ASC, CASE WHEN Grade < 8 THEN Marks ELSE NULL END ASC;