If I have a table named Employee with the data below. Write an update SQL statement to change the salary to $500$ for John.

CustomerID Name Address Salary

$1$ Sarah $1234$ Lane $200$

$2$ John PO Box $223.100$