Hello! I'm currently stuck on Step 2 of Challenge: Gradebook. I don't know what I'm doing wrong but I would appreciate it if you pointed out my error.
SELECT name, number_grade, CASE
WHEN number_grade > 90 THEN "A"
WHEN number_grade > 80 THEN "B"
WHEN number_grade > 70 THEN "C"
ELSE "F"
END AS letter_grade, COUNT(*) AS student_count
FROM student_grades GROUP BY letter_grade;
In Step 2 of the Gradebook Challenge, we are asked to create
a table that shows how many students have earned which
letter_grade.
We are told
You can output the
letter_gradeby usingCASEwith thenumber_gradecolumn, outputting 'A' for grades > 90, 'B' for grades > 80, 'C' for grades > 70, and 'F' otherwise.
which you have in your code.
And then we are told
Then you can use
COUNTwithGROUP BYto show the number of students with each of those grades.
I don't see this in your code.
Also, we are not asked for the name or number_grade in this Step.
Vui lòng đăng nhập để lại bình luận.