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

图片说明

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

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