27,579
社区成员
发帖
与我相关
我的任务
分享
--1
SELECT [user name] as 用户,COUNT(orders) as 订单总数
FROM [table 1] GROUP BY [user name]
--2
SELECT a.[user name] as 用户,COUNT(a.orders) as 订单总数,b.sex
from [table1] a
left join[table2] b on a.[user name]=b.[user name]
group by a.[user name],b.sex
---问题一
select username,count(orders),date
from tab
group by username,date
--问题二
---sex代表性别 high代表身高,weight代表体重
select a.username,a.sex,a.weight,count(a.orders)
from tb a,tab b
where a.username=b.username
group by a.username,a.sex,a.weight
---问题一
select username,count(orders),date
from tab
group by username,date
--问题二
---sex代表性别 high代表身高,weight代表体重
select a.username,a.sex,a.weight,count(a.orders)
from tb a,tab b
where a.username=b.username
group a.username,a.sex,a.weight
SELECT CNT,U.SEX
FROM(
SELECT [user name],COUNT(orders)CNT
FROM TAB
GROUP BY [user name]
)M,UserDetail U
WHERE M.[USER NAME]=U.[USER NAME]
SELECT [user name],COUNT(orders)CNT
FROM TAB
GROUP BY [user name]
select b.xb,b.xm,订单总数=count(*) from A
left join B on a.xm=b.xm
group by b.xb,b.xm
--knowlege :group by
1>
select username,count(orders),date
from ta_user group by username,date
-- knowlege: join...on...
2>
select a.username,a.sex,a.weight,count(a.orders)
from tb_user a join tab_customer b
on a.username=b.username
group by a.username,a.sex,a.weight