A.inner join B.left join C.full join D.union all
A.select id,max(score)from student group by id B.select distinctidfromstudent C.select id from student D.select id from student where id is not null
A.round B.max C.abs D.now