select MyAlias.* from
>(
> select hired from employee where hired between '2011-1-5' and '2015-12-31'
>) as MyAlias


which will clarify any join you add in similar notation