Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Here is my temp table to get the numerical grade I need the statement to find that given table. create temporary table numericalgrade (select ID,
Here is my temp table to get the numerical grade I need the statement to find that given table.
create temporary table numericalgrade (select ID, (case when grade = "A" then 4.0 when grade = "A-" then 3.7 when grade = "B+" then 3.3 when grade = "B" then 3.0 when grade = "B-" then 2.7 when grade = "C+" then 2.3 when grade = "C" then 2.0 when grade = "C-" then 1.7 when grade = "D+" then 1.3 when grade = "D" then 1 when grade = "D-" then 0.7 when grade = "F" then 0 end) as numGrade from takes);
Thanks in advance!!
Query 1: Calculate GPA for each student First you need to turn letter grade into numeric grade: A: 4.0;A:3.7;B+:3.3;B:3.0;B:2.7;C+:2.3;C:2.0;C:1.7;D+:1.3;D:1;D:0.7;F:0 The GPA is calculated with the following formula (Don't include null grade in the calculation): GPA=sum(numericalgradecredits)/sum(credits) Please round the decimals to the hundredths place. Here is the correct query result for your referenceStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started