changing the value of a column in a table based on the value of another column
here is the syntax :
 update class
 inner join (
    select class_number, count(*) totalSize
    from class
    group by class_number
 ) cc on class.class_number = cc.class_number
 set class.class_size = totalSize