Question: 2. Using the same test scores table from the previous question, apply a CASE expression to determine the final grade based on the course's Pass/Fail

2. Using the same test scores table from the previous question, apply a CASE expression to determine the final grade based on the course's Pass/Fail criteria. To pass, a student must achieve at least 60% on the midterm and a minimum of 10% on the final exam. Assume all students received 10% on the final exam. First, add two columns to the existing table: Final Score (midterm score + final exam score) Final Grade (Pass "P" or Fail "F") Update the table accordingly. Write a query that returns only one student who fails the course

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 Mathematics Questions!