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, numbergrade, and percentcompleted, which you can compute by multiplying and rounding the fractioncompleted column. Now, this step is a little tricky. The goal is a table that shows how many students have earned which lettergrade. You can output the lettergradeby using CASEwith the numbergradecolumn outputting A for grades B for grades C for grades 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
