What rank is Captain Conway?
select rank from captain where name like '%conway%'
What is the average age of the midshipmans
select avg ( age ) from captain where rank = 'Midshipman'
What class of captain named Lieutenant Hugh Bolitho?
select class from captain where name = 'Lieutenant hugh Bolitho'