Database: ship_1
Question: Find the name of captains whose rank are either Midshipman or Lieutenant.
SQL:
SELECT name FROM captain WHERE rank  =  'Midshipman' OR rank  =  'Lieutenant'