34,838
社区成员




select a.city,(isnull(a.score,0)+isnull(c.score,0))/2
from t1 a
left join t3 b
on a.city=b.city
left join t2 c
on b.province=c.province
select a.city,(a.score+isnull(c.score,0))/2
from t1 a
left join
t3 b
on a.city=b.city
left join t2 c
on b.province=c.province