The Report

Sort by

recency

|

3508 Discussions

|

  • + 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

  • + 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

  • + 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;
    
  • + 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

  • + 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;