Jovanna.P0912

SELECT COUNT(*),CASE WHEN number_grade > 90 THEN 'A'WHEN number_grade > 80 AND number_grade <= 90 THEN 'B'WHEN number_grade > 70 AND number_grade <= 80 THEN 'C'ELSE 'F'END AS letter_gradeFROM stude...

1. Communauté
2. Computing Platform Community Discussions
3. Help me please!! Then you can use COUNT with GROUP BY to show the number of students with each of those grades.