Database: ship_1
Question: Find the name and flag of ships that are not steered by any captain with Midshipman rank.
SQL:
SELECT name ,  flag FROM ship WHERE ship_id NOT IN (SELECT ship_id FROM captain WHERE rank  =  'Midshipman')