select ... 
  from (select ...) alias