Find job id and date of hire for those employees who was hired between November 5th, 2007 and July 5th, 2009.
return employees ;return date of hire of  #1 ;return #1 where #2 is higher than November 5th ,  2007 ;return #3 where #2 is lower than July 5th ,  2009 ;return job id of #4 ;return date of hire of  #4 ;return #5 ,  #6
['select', 'project', 'comparative', 'comparative', 'project', 'project', 'union']