join group by 帮我写个 sql 语句

2025-02-27 23:02:51
推荐回答(1个)
回答1:

select Company.Property,sum(Information.Number) as TotalNumber from Company inner join Information on Company.CompanyName=Information.CompanyName
group by Company.Property