下面选项中，更新account表中money字段值，其取值在100-200之间，现在将money字段值增加50，能够正确执行上述要求的SQL语句是

题目：下面选项中，更新account表中money字段值，其取值在100-200之间，现在将money字段值增加50，能够正确执行上述要求的SQL语句是

A. update account set money + 50 where money >=100 and money <=200;

B. update account set money = money + 50 where money >=100 or money <=200;

C. update account set money = money + 50 where money between 100 and 200;

D. update account set money = money + 50 where money <=200 and money >=100;

答案：评论后可见此内容