What are the names of captains that have either the rank Midshipman or Lieutenant?
select name from captain where rank = 'Midshipman' or rank = 'Lieutenant'