一道面试题，看看这题咋做，SQL题

Question

Answer 1

select p.Name,t.Education,max(t.Point),cast(avg(t.Point) as decimal(18,2)) from Test t left join Position p on t.PositionID = p.PositionID
where (p.Name='开发工程师' or p.Name='产品助理') and (t.Education='本科' or t.Education = '硕士') order by p.Name,p.Education