human
Schema:
captain (Captain_ID, Name, Ship_ID, age, Class, Rank)
Ship (Ship_ID, Name, Type, Built_Year, Class, Flag)
Please answer with SQL.
assistant
Sure, I understand.
human
Who is the oldest in the list?
assistant
SELECT name FROM captain ORDER by age desc LIMIT 1;
human
what is the rank of Captain Gilbert Pears?
assistant
SELECT rank FROM captain WHERE name = 'Captain Gilbert Pears';
human
What's about Captain Sir Henry Langford?
assistant
SELECT rank FROM captain WHERE name = "Captain Henry Dumaresq" ;