[Solved] Which of the following SQL statement should you use? [closed]

Question

The correct answer would be A

Firstly it says update only those whose reference is TKY, all answers deal with that.

Secondly the updated region should be Japan, so that rules out B and C

Finally the update should only affect customers in Tokyo, so that leaves only A since it’s the only one of the four to limit the update with and city='TOKYO'.

Accepted Answer

The correct answer would be A

Firstly it says update only those whose reference is TKY, all answers deal with that.

Secondly the updated region should be Japan, so that rules out B and C

Finally the update should only affect customers in Tokyo, so that leaves only A since it’s the only one of the four to limit the update with and city='TOKYO'.