Find the name of captains whose rank are either Midshipman or Lieutenant.
SELECT name FROM captain WHERE rank  =  'Midshipman' OR rank  =  'Lieutenant'
SELECT name FROM captain WHERE rank  =  'Midshipman' OR rank  =  'Lieutenant'
[{'Name': 'Captain Sir Henry Langford'}, {'Name': 'Captain Beves Conway'}, {'Name': 'Lieutenant Hugh Bolitho'}, {'Name': 'Lieutenant Montagu Verling'}, {'Name': 'Captain Henry Dumaresq'}, {'Name': 'Captain Gilbert Pears'}]