統計抽出數據
===
## 知識點
- 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 ;
```