I want to update a table named "test" with some sub-query where sub-query is the same "test" table. I wrote the below S...