Question

Write a SQL update statement that changes the grade for student 4456 who passed the course Discrete Math in semester 2017Sp. Change the grade from C to B.   For full credit you should have a single update statement that has a where clause that verifies that the current grade is C. Use ap as the Schema Table to find your answer

whoevr is solving this problem thank you. heres wht i needu to do. Thge question is the bold part above ^. type a query statement using mysql workbench. then run the statement with a schema that works for it. lastly, provide a screenshot letting me know that the statement works. in other words, all i need is the query statement, which schema u used, and a small screenshot. once again thank you this will help m e out. if you have any qustions, let me knoiw in the comments sectionss below.

Answer 1

The Schema that is used is provided below with the screenshot after the execution.

Schema:

create table student(studentId int(10),Course char(10),semester varchar2(10),grade char(2));

insert into student values(4456,"Discrete Math","2017Sp","C");

insert into student values(4457,"Networks","2014Sp","C");

insert into student values(5215,"Java","2017Summer","A");

insert into student values(4453,"Discrete Math","2017Sp","B");

insert into student values(4452,"Science","2012Sp","C");

SQL query:

update student set grade="B" where studentId=4456 and grade="C";

Output: