那就用:
  select a, b
     from 表 as 表1
     where b> (
               select avg(b)
               from 表 as 表2
               )