CREATE TABLE Ship (Ship_ID NUMBER, Name CLOB, Type CLOB, Built_Year FLOAT, Class CLOB, Flag CLOB)
CREATE TABLE captain (Captain_ID NUMBER, Name CLOB, Ship_ID NUMBER, age CLOB, Class CLOB, Rank CLOB)

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