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. Practice
  2. SQL
  3. Basic Join
  4. The Report
  5. Discussions

The Report

  • kcuck + 1 comment

    WORKED FOR ME

    SELECT Name = CASE WHEN G.Grade >7 THEN S.Name ELSE NULL END, G.Grade , S.Marks FROM Students S INNER JOIN Grades G ON S.Marks >= G.Min_Mark AND S.Marks <= G.Max_Mark ORDER BY Grade DESC,Name,Marks;

    • andremlsantos + 1 comment

      I can't use this script. In the name field, its printed 1, instead of the correct name. This is the output returned:

      1 10 95 
1 10 94 
1 10 96 
1 10 100 
1 10 99 
1 9 89 
1 9 88 
1 9 81 
1 9 87 
1 9 80 
1 9 84 
1 8 77 
1 8 78 
1 8 74 
1 8 76 
1 8 77 
NULL 7 64 
NULL 7 66 
NULL 6 55 
NULL 4 34 
NULL 3 24
      • colonel_bishop + 1 comment

        in place of 'SELECT NAME = CASE' in first line, use 'SELECT CASE' because I think the former one is evaluating in 1 and 0(boolean)

        • anusweetyda + 1 comment

          why should we use case..? pls explain..

          • plj_coding + 0 comments

            It adds a conditional data value for the name column. The name of the student in the current row or NULL