What are the job ids and dates of hire for employees hired after November 5th, 2007 and before July 5th, 2009?
return employees ;return the  dates of  hire for #1 ;return #1 where #2 is  after November 5th  2007 ;return #3 where #2 is  before July 5th  2009 ;return the  job ids of  #4 ;return the  dates of  hire of #4 ;return #5 ,  #6
['select', 'project', 'comparative', 'comparative', 'project', 'project', 'union']