[凡鸽鸽]《课内学习11》MYSQL 实验11group by子句

课内学习11 — MYSQL

实验11group by子句源码如下：

1.create database xscj;
use xscj;
source C:\Users\Administrator\Desktop\sy111.sql

2.create database yggl;
use yggl;
source C:\Users\Administrator\Desktop\sy112.sql

3.select 学历,性别,count(*) as '人数' from employees
group by 学历,性别;


4.select left(电话,1) as 电话首位,count(*) as 人数 from employees
group by 电话首位;

5.select 部门名称,avg(收入) as 平均收入 from departments join employees using(部门号)
join salary using(编号)
group by 部门名称;