select o.state_abbr, s.state, o.[count]from states sinner join( select state_abbr, count(*) as count from orgs group by state_abbr) oon s.state_abbr = o.state_abbr
select o.state_abbr, s.state, o.[count]from states sinner join( select state_abbr, count(*) as count from orgs group by state_abbr) oon s.state_abbr = o.state_abbr
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
