group by

select price,count(*),sum(price),min(price),max(price),avg(price) from t1 group by price;

针对price分组，分组之后只能获得每组的信息,可以取数量，一些聚合函数

select * from t1 group by price;毫无意义。