select x.* from (

  select something, anotherthing,

  (select sum(thirdthing) from second b where b.something = a.something) total

  from a

) x where x.total > 10