6.SELECT *,base_salary+title_salary AS 应发工资,base_salary+title_salary-deduction AS 实发工资 FROM (department AS d INNER JOIN employee AS e ON d.`depid`=e.`depid`) INNER JOIN salary AS s ON e.`empid`=s.`empid`;
7.SELECT * FROM employee WHERE employee.`NAME` LIKE "张%" AND YEAR(NOW())-YEAR(birthday)<40;
8.SELECT *,base_salary+title_salary-deduction AS 实发工资 FROM (department AS d INNER JOIN employee AS e ON d.`depid`=e.`depid`) INNER JOIN salary AS s ON e.`empid`=s.`empid` WHERE e.depid=(SELECT depid FROM department WHERE depname='销售部');
9.SELECT title,COUNT(*) FROM employee GROUP BY title;
10.SELECT depname,SUM(base_salary+title_salary-deduction) AS 实发工资总和,AVG(base_salary+title_salary-deduction) AS 平均工资 FROM (department AS d INNER JOIN employee AS e ON d.`depid`=e.`depid`) INNER JOIN salary AS s ON e.`empid`=s.`empid` GROUP BY d.`depname`;
11.SELECT e.`NAME`,(s.base_salary + s.title_salary - s.deduction) AS 实际月收入 FROM (department AS d INNER JOIN employee AS e ON d.`depid`=e.`depid`) INNER JOIN salary AS s ON e.`empid`=s.`empid` WHERE (s.base_salary + s.title_salary - s.deduction)>(SELECT MAX(s.base_salary) FROM (department AS d INNER JOIN employee AS e ON d.`depid`=e.`depid`) INNER JOIN salary AS s ON e.`empid`=s.`empid` WHERE d.depname = '销售部');