What are the names and flags of ships that do not have a captain with the rank of Midshipman?
return ranks ;return #1 besides  Midshipman ;return captains with #2 ;return ships of  #3 ;return names of  #4 ;return flags of  #4 ;return #5 ,  #6
['select', 'discard', 'project', 'project', 'project', 'project', 'union']