Find the name and flag of ships that are not steered by any captain with Midshipman rank.
select name, flag from ship where ship_id not in (select ship_id from captain where rank = 'Midshipman')