query: 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'
question: Find that name of the ships that what are steered them by both a captain with Midshipman rank and a captain with Lieutenant rank.
query_toks: 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 '
query_toks_no_value: 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
question_toks: Find that name of the ships that what are steered them by both a captain with Midshipman rank and a captain with Lieutenant rank.