Adding average mark of each student. update student3_avg a LEFT JOIN (select id, sum(social + math + science )/3 as number FROM student3_avg group by id) as b ...
確定! 回上一頁