统计抽出数据
===
## 知识点
- distinct # 过滤重复的数据
- sum
- max/min
- group by/haing
## 实战
```
> select distinct team from users;
> select sum(score) from users;
> select max(socre) from users;
> select min(score) from users;
> select * from users where score = (select max(score) from users);
> select * from users where score = (select min(score) from users);
> select team,max(score) from users group by team;
> select team,max(score) from users group by team having max(score) >= 25;
> select team,max(score) from users group by team having max(score) >= 25 ;
```
