Write a SQL query to update the 'status' column of all rows in a table named 'tasks' to 'Completed' where the 'completion_date' is not null.

 UPDATE tasks

SET status = 'Completed'

WHERE completion_date IS NOT NULL;