1.查询公司员工工资的最大值、最小值、平均值、总和
SELECT MAX(salary) , MIN(salary), ROUND(AVG(salary), 2), SUM(salary)
FROM employees;
2.查询员工表中的最大入职时间和最小入职时间的相差天数(DIFFRENCE)
【datediff函数:支持的两个参数都为日期类型。相差天数。】
SELECT DATEDIFF(‘2017-10-1’, ‘2017-9-29’);
SELECT DATEDIFF(NOW(), ‘1995-1-1’);
SELECT DATEDIFF(MAX(hiredate), MIN(hiredate)) DIFFRENCE FROM employees;
3.查询部门编号为90的员工个数
SELECT COUNT(*) # step1
FROM employees # step3
WHERE department_id = 90; # step2