客户信用评价表(client_credit)中有脆弱性评分字段(f_score(FLOAT)),由于疫情原因,现要把所有该字段数值在55至60之间的客户的该字段数值减少5,以下SQL正确的是()。
A.UPDATE client_credit SET f_score=f_score-5 B.UPDATE client_credit SET f_score=f_score-5 WHERE f_score>=55 OR f_score<=60 C.UPDATE client_credit SET f_score=f_score-5 WHERE f_score BETWEEN 55 AND 60 D.UPDATE client_credit SET f_score=f_score-5 WHERE f_score>=55 AND f_score<=60正确答案CD