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')
SELECT name ,  flag FROM ship WHERE ship_id NOT IN (SELECT ship_id FROM captain WHERE rank  =  'Midshipman')
[{'Name': 'HMS Destiny', 'Flag': 'Panama'}, {'Name': 'HMS Trojan', 'Flag': 'Panama'}, {'Name': 'HM Sloop Sparrow', 'Flag': 'Panama'}, {'Name': 'HMS Phalarope', 'Flag': 'Panama'}, {'Name': 'HMS Undine', 'Flag': 'Malta'}]