CREATE TABLE captain (captain_id NUMBER, name CLOB, ship_id NUMBER, age CLOB, class CLOB, rank CLOB)
CREATE TABLE ship (ship_id NUMBER, name CLOB, type CLOB, built_year NUMBER, class CLOB, flag CLOB)

What are the ranks of captains that are both in the Cutter and Armed schooner classes?
SELECT rank FROM captain WHERE class = 'Cutter' INTERSECT SELECT rank FROM captain WHERE class = 'Armed schooner'
SELECT "rank" FROM "captain" WHERE "class" = 'Cutter' INTERSECT SELECT "rank" FROM "captain" WHERE "class" = 'Armed schooner'