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

  • jc65537
     + 11 comments

    This works for me
    MYSQL

    select 
   if(Grades.Grade < 8, concat('NULL'),Students.Name), 
   Grades.Grade, 
   Students.Marks 
   from Students 
   inner join Grades 
   on Students.Marks >= Grades.Min_Mark 
   and Students.Marks <= Grades.Max_Mark 
   group by 
   Grades.Grade desc, 
   Students.Name, Students.Marks asc


    Output

    Britney 10 95 
Heraldo 10 94 
Julia 10 96 
Kristeen 10 100 
Stuart 10 99 
Amina 9 89 
Christene 9 88 
Salma 9 81 
Samantha 9 87 
Scarlet 9 80 
Vivek 9 84 
Aamina 8 77 
Belvet 8 78 
Paige 8 74 
Priya 8 76 
Priyanka 8 77 
NULL 7 64 
NULL 7 66 
NULL 6 55 
NULL 4 34 
NULL 3 24