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
What rank is Captain Conway?
assistant
SELECT Rank FROM captain WHERE name LIKE '%Conway%';
human
What is the average age of the midshipmans
assistant
SELECT AVG ( age ) FROM captain WHERE Rank = "Midshipman" ;