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

|

3597 Discussions

|

  • nibinsebastian01
     + 0 comments
    SELECT
    CASE
        WHEN g.Grade > 7 THEN s.Name
        ELSE NULL
    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 > 7 THEN s.Name
        ELSE NULL
    END ASC,
    CASE
        WHEN g.Grade < 8 THEN g.Grade
        ELSE NULL
    END DESC,
    CASE
        WHEN g.Grade < 8 THEN s.Marks
        ELSE NULL
    END ASC;

  • tarasovvolodya
     + 0 comments

    (SELECT Name, Grade, Marks FROM STUDENTS LEFT JOIN GRADES ON STUDENTS.MARKS BETWEEN Min_Mark AND Max_Mark WHERE Grade >= 8 )

    UNION ALL

    (SELECT NULL AS Name, Grade, Marks FROM STUDENTS LEFT JOIN GRADES ON STUDENTS.MARKS BETWEEN Min_Mark AND Max_Mark WHERE Grade < 8 ) ORDER BY grade DESC, name ASC,marks ASC;

  • amandacaravieri1
     + 1 comment
    select 
    case when grade<8 then NULL 
    else name
    end as name, 
    grade, 
    marks
from students s
left join grades g 
on s.marks between g.min_mark and g.max_mark
order by grade desc, name,marks

  • debaprasadsahu_1
     + 0 comments

    Please have the correct code I have tried:

    SELECT CASE WHEN g.grade >= 8 THEN s.name ELSE NULL 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 WHEN g.grade < 8 THEN CAST(s.marks AS VARCHAR) END;

  • alewnas
     + 0 comments
    WITH t1 as(
        SELECT
        id, name, marks, grade, min_mark, max_mark
        FROM students
        CROSS JOIN grades
        WHERE marks BETWEEN min_mark AND max_mark
        ORDER BY id
)
(
SELECT 
    name, grade,marks
FROM t1
WHERE grade >=8 

)
UNION ALL
(
SELECT 
    'NULL' AS name, grade,marks
FROM t1
WHERE grade <8 
)ORDER BY grade DESC, name ASC,marks ASC