Question: We've created a database to track student grades, with their name, number grade, and what percent of activities they've completed. In this first step, select

We've created a database to track student grades, with their name, number grade, and what percent of activities they've completed. In this first step, select all of the rows, and display the name, number_grade, and percent_completed, which you can compute by multiplying and rounding the fraction_completed column. Now, this step is a little tricky. The goal is a table that shows how many students have earned which letter_grade. You can output the letter_gradeby using CASEwith the number_gradecolumn, outputting 'A' for grades >90,'B' for grades >80,'C' for grades >70, and 'F' otherwise. Then you can use COUNTwith GROUP BYto show the number of students with each of those grades.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!