Find the name of captains whose rank are either Midshipman or Lieutenant.
select name from captain where rank = 'Midshipman' or rank = 'Lieutenant'