How many captains are either Midshipman or Lieutenant?
select count(*) from captain where rank = 'Midshipman' or rank = 'Lieutenant'
What are their names?
select name from captain where rank = 'Midshipman' or rank = 'Lieutenant'