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