SQL查询总结
SQL查询总结转载 OrderID
Region
Total
1
A
100.00
2
C
80.00
3
A
130.00
4
B
90.00
5
B
100.00
6
C
120.00
7
A

Sql语句：

select *

from sales as s

inner join (select avg(total) as avge,region fromsales group by region) avgtable

on s.region = avgtable.region

where total > avgtable.avge