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 reference