Database: ship_1
Question: What are the names and flags of ships that do not have a captain with the rank of Midshipman?
SQL:
SELECT name ,  flag FROM ship WHERE ship_id NOT IN (SELECT ship_id FROM captain WHERE rank  =  'Midshipman')