sql语句:把低于总平均成绩的女同学成绩提高5分。
UPDATE students SET grade = grade + 5 WHERE gender = 'Female' AND grade < (SELECT AVG(grade) FROM students)
原文地址: https://www.cveoy.top/t/topic/ds8Y 著作权归作者所有。请勿转载和采集!
安全问答是一个知识全球问答,包含丰富的问答知识
UPDATE students SET grade = grade + 5 WHERE gender = 'Female' AND grade < (SELECT AVG(grade) FROM students)
原文地址: https://www.cveoy.top/t/topic/ds8Y 著作权归作者所有。请勿转载和采集!