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

|

3508 Discussions

|

  • iiroy2049
     + 0 comments

    MYSQL:-

    select if(grade<8,NULL,name), grade, marks from students join grades where students.marks between grades.min_mark and grades.max_mark order by grade desc, name asc

  • sid_rahmat786
     + 0 comments

    SELECT CASE WHEN GRADES.GRADE >= 8 THEN STUDENTS.NAME ELSE NULL END,GRADES.GRADE,STUDENTS.MARKS FROM STUDENTS JOIN GRADES ON STUDENTS.MARKS BETWEEN GRADES.MIN_MARK AND GRADES.MAX_MARK ORDER BY GRADES.GRADE DESC, STUDENTS.NAME

  • pralay_g
     + 0 comments
    SELECT
    CASE
        WHEN G.[Grade] < 8 THEN NULL
        ELSE S.[Name]
    END AS StudentName,
    G.[Grade] AS StudentGrade,
    S.[Marks] AS StudentMarks
FROM Students AS S
INNER 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.[Name]
        ELSE CAST(S.[Marks] AS VARCHAR(20))
    END ASC;

  • mohamednourelde1
     + 0 comments

    /* the solution */ select case when G.Grade <8 then null else S.Name end as Name,G.Grade ,S.Marks from Students as S inner join Grades as G on S.Marks between G.Min_Mark and G.Max_Mark order by G.Grade desc,S.Name,S.Marks

  • sai2043
     + 0 comments

    SELECT CASE WHEN MARKS BETWEEN 70 AND 100 THEN NAME ELSE NULL END AS NAMES, CASE WHEN MARKS BETWEEN MIN_MARK AND MAX_MARK THEN GRADE END, MARKS FROM STUDENTS JOIN GRADES ON MARKS BETWEEN MIN_MARK AND MAX_MARK ORDER BY GRADE DESC, NAME ASC;