select sum(gdsaleqty) from goods;
select max(gdprice) from goods;
select count(distinct uid)from orders;
select uid,usex,ucity
from users
group by ucity;\
select ucity,count(*)
from users
group by ucity;
select ucity,group_concat(uid) as uids
from users
group by ucity;
select ucity,group_concat(uid order by uid separator '_') as uids
from users
group by ucity;
select ucity,count(*)
from users
where ucity in('长沙','上海')
group by ucity;
select ucity,count(*)
from users
where ucity in('长沙','上海')
group by ucity
with rollup;
select ucity,count(*)
from users
group by ucity
having count(*)>=3;