SELECT t1.name FROM ship AS t1 JOIN captain AS t2 ON t1.ship_id  =  t2.ship_id WHERE t2.rank  =  'Midshipman' INTERSECT SELECT t1.name FROM ship AS t1 JOIN captain AS t2 ON t1.ship_id  =  t2.ship_id WHERE t2.rank  =  'Lieutenant'
Find the name of the ships that are steered by both a captain with Midshipman rank and a captain with Lieutenant rank.
SELECT t1.name FROM ship AS t1 JOIN captain AS t2 ON t1.ship_id = t2.ship_id WHERE t2.rank = 'Midshipman ' INTERSECT SELECT t1.name FROM ship AS t1 JOIN captain AS t2 ON t1.ship_id = t2.ship_id WHERE t2.rank = 'Lieutenant '
select t1 . name from ship as t1 join captain as t2 on t1 . ship_id = t2 . ship_id where t2 . rank = value intersect select t1 . name from ship as t1 join captain as t2 on t1 . ship_id = t2 . ship_id where t2 . rank = value
Find the name of the ships that are steered by both a captain with Midshipman rank and a captain with Lieutenant rank .