Database: ship_1
Question: What are the names of captains that have either the rank Midshipman or Lieutenant?
SQL:
SELECT name FROM captain WHERE rank  =  'Midshipman' OR rank  =  'Lieutenant'