query: SELECT name ,  flag FROM ship WHERE ship_id NOT IN (SELECT ship_id FROM captain WHERE rank  =  'Midshipman')
question: What-what names and flags of ships that do not have captain with rank of Midshipman?
query_toks: SELECT name , flag FROM ship WHERE ship_id NOT IN ( SELECT ship_id FROM captain WHERE rank = 'Midshipman ' )
query_toks_no_value: select name , flag from ship where ship_id not in ( select ship_id from captain where rank = value )
question_toks: What-what names and flags of ships that do not have captain with rank of Midshipman?