SQL

Question

Fill in the blanks to update the ''students'' table by changing the university's value to ''Stanford'' if the student's name is ''John''. is the question...The Keywords are:
ON, JOIN, UPDATE, SET, WHERE, SELECT..

I am having the toughest time with this one, can anyone help ??

Answer 1

update students set university ="Stanford" where name="John";