Question

In the table "Student", Priya wanted to increase the Marks (Column Name : Marks) of those students by 5 who have got Marks below 33. She has entered the following statement :

SELECT Marks + 5 FROM Student WHERE Marks<33;

Identify errors (if any) in the above statement. Rewrite the correct SQL statement.

Answer 1

Correct statement-

UPDATE Student SET Marks = Marks * 5 WHERE Marks < 33;