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

|

3552 Discussions

|

  • tocciemanuele03
     + 0 comments

    What is wrong with my solution?

    SELECT 
  CASE WHEN g.grade >= 8 THEN s.name ELSE NULL END AS Name,
  g.grade AS Grade,
  s.marks AS Mark
FROM students s, grades g
WHERE g.grade BETWEEN 1 AND 10 
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;

  • mohit8350
     + 0 comments

    what is worng with my solution?

    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 FLOOR(S.Marks/10)+1 = G.Grade 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;

  • chuongle241205
     + 0 comments

    SQL SEVER: SELECT IIF(G.GRADE >= 8, S.NAME, 'NULL'), G.GRADE, S.MARKS FROM STUDENTS S JOIN GRADES G ON (S.MARKS <= G.MAX_MARK) AND (S.MARKS >= G.MIN_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

  • knocknotknock
     + 0 comments
    SELECT
    CASE
        WHEN g.min_mark >=70 THEN s.name
        ELSE NULL
    END AS name,
    grade,
    marks
FROM
    students s
    JOIN grades g ON s.marks BETWEEN g.min_mark AND g.max_mark
ORDER BY
    grade DESC, name,
    (CASE
        WHEN name IS NULL THEN grade
    END) DESC,
    marks;

  • nkashid99
     + 0 comments

    select (Case when g.grade>7 then s.name else null end) Name, g.grade Grade, s.marks Marks from students s left join grades g on (s.marks >= g.min_mark and s.marks <= g.max_mark) order by Grade Desc, Name, marks;