createtabledd(

user_idint,

class_noint,

scoreint

);

insertintoddvalues(1,1,1),(2,1,1),(3,1,2),(4,2,2);

selectclass_no,avg(score)fromddgroupbyclass_noorderbyavg(score);