sample149.sql

T-SQL示例大全

/* 文件名称: Sample149.sql */
USE 北风贸易

SELECT 部门,
       COUNT(*) AS 部门员工人数,
       MAX(目前薪资) AS 部门最高薪资,
       MIN(目前薪资) AS 部门最低薪资,
       AVG(目前薪资) AS 部门平均薪资
  FROM 飞狐工作室
  GROUP BY 部门