2018年总工资
select sum(s_money) from c where s_date like '2018%'
2018年平均工资
select avg(s_money) from c where s_date like '2018%'
2018年年收入大于10万的员工
select b.e_name,t.s_money from b,(select e_id,sum(s_money) as s_money from c where s_date like '2018%' group by e_id) t where b.e_id = t.e_id and t.s_money >100000
2019年1月各部门的平均工资
select d_name,avg(c.s_money) as s_money from a,b,c where a.d_id = b.d_id and b.e_id = c.e_id and s_date = '201901' group by d_name
有问题请追问
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024