查询年龄大于25岁的员工最高工资:
mysql> select max(fsalary) from t_employee where fage>25;
+--------------+
| max(fsalary) |
+--------------+
| 6200 |
+--------------+
1 row in set
查询工资大于3800元的员工平均年龄:
mysql> select avg(fage) from t_employee where fsalary>3800;
+-----------+
| avg(fage) |
+-----------+
| 25.8000 |
+-----------+
1 row in set
查询每月公司需要支付员工工资总数:
mysql> select sum(fsalary) from t_employee;
+--------------+
| sum(fsalary) |
+--------------+
| 34302.04 |
+--------------+
1 row in set
mysql> select min(fsalary),max(fsalary) from t_employee;
+--------------+--------------+
| min(fsalary) | max(fsalary) |
+--------------+--------------+
| 1200 | 8300 |
+--------------+--------------+
1 row in set