Update the data in the Employees table so that employees with the following managers are listed as working in the following departments:

The UPDATE statement in SQL. I cant figure the statement, I keep getting syntax error. Help.

ReportsTo Department

Andrew Fuller Sales
Steven Buchannan Marketing
All Others CEO