instruction: What is the total number of flags of ships that do not have a captain with the rank of Midshipman? Show the result using a bar chart.
response: SELECT Flag, COUNT(Flag) FROM Ship WHERE NOT Ship_ID IN (SELECT Ship_ID FROM captain WHERE Rank = 'Midshipman') GROUP BY Flag