Find the name and flag of ships that are not steered by any captain with Midshipman rank.
return captains ;return ranks of  #1 ;return #1 where  #2 is  not  Midshipman ;return ships of  #3 ;return names of  #4 ;return flags of  #4 ;return #5 ,   #6
['select', 'project', 'comparative', 'project', 'project', 'project', 'union']